Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “quin” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

159 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
quin13582392(None) 
quid144922351quid
quins144819851quins
quint144529901quint
quip154818621quip
quit136136511quit
quiz224920001quiz
quoin144012321quoin
ruin47430511ruin
agin56132712agin
ain37579092_ain
akin86328032akin
amin66042252amin
auxin121411912auxin
ayin76331742ayin
bin56658642_bin
blin67228172blin
brin67038192brin
bruin75818332bruin
bun56348142bu_n
bunn65023652bunn
burin75626062burin
burn65636432burn
cain65643912cain
chin96934742chin
coin66645352coin
cuif96529142cuif
cuing85420192cuing
cumin94616972cumin
curn66731892curn
cutin75022782cutin
din46459462_din
djin12911632djin
dui46433382dui_
duit56241582duit
dun46545582du_n
durn56127632durn
equid154610322equid
equine151711572equine
equip16467262equip
fain75840562fain
fin66458032_fin
foin77231562foin
fun66841142fu_n
gain56042162gain
gin46055752_gin
grin55733722grin
guan55325582guan
guid66022822guid
gun47240802gu_n
hin67559562_hin
huic94818052huic
hun65844712hu_n
in28150862__in
jin106443932_jin
join116724832join
jun105932062ju_n
kain85334292kain
kin76353972_kin
lain46146282lain
lin37967372_lin
loin46838722loin
lupin75215842lupin
main65345522main
mucin93116822mucin
mun56143862mu_n
muni65824412muni
muon65722732muon
nun35537742nu_n
pain65647242pain
pein65834942pein
pin57066722_pin
pun58846512pu_n
purin75527592purin
pyin96823232pyin
qaid146023842qaid
qi116526902q_i_
qis126934382q_is
qua124821972qu_a
quad144618702quad
quag144815942quag
quai134420392quai
quail144314362quail
quaint15415172quaint
quais144618392quais
quant143624812quant
quay164618352quay
qubit164218992qubit
quean143612842quean
queen144312062queen
quern143610402quern
quey164616472quey
quick204311062quick
quids154917462quids
quiet144530732quiet
quiff201111562quiff
quill148413772quill
quilt144125102quilt
quince173910132quince
quinic17319472quinic
quinin152811952quinin
quinoa15377652quinoa
quinol15357972quinol
quinsy18386352quinsy
quinta153312372quinta
quinte153414522quinte
quints154316562quints
quips164713372quips
quipu164811642quipu
quire144917132quire
quirk184011002quirk
quirt144624232quirt
quite144621462quite
quits144122352quits
quod145413622quod
quoins154110582quoins
quoit143819862quoit
rain46251732rain
rein46040892rein
requin15310712requin
rin36663182_rin
ruing67221052ruing
ruins55822032ruins
run36244992ru_n
rutin55421342rutin
sain45551292sain
sequin1538522sequin
shin75634312shin
sin36265892_sin
skin85927532skin
spin66231302spin
squib163710502squib
squid154211902squid
squint154214792squint
suing65026362suing
suint55638182suint
suit45649872suit
sun37149032su_n
sunn45423592sunn
tain45548072tain
thin76732392thin
tin36362172_tin
tui37034022tui_
tuis44829642tuis
tun35845192tu_n
turn46330392turn
twin76023082twin
tyin76424002tyin
un28341142_u_n
urn35731472_urn
vain75233002vain
vein75625752vein
wain75840202wain
whin105225692whin
win66456292_win
yin67648732_yin
yuan76120012yuan
zein135620602zein
zin125643772_zin

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691298720.263679433.5
2DLD Change Limit298721590.84335435.3
3Display Results1591590.0463456.5
 (SQL Overall)1786911591.152155113.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.