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 “faquirs” with Change Limit: [1] [2] [3]

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

146 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
faquirs194386(None) 
faqirs18456031faq_irs
faquir1834311faquir_
fairs85825442fa__irs
fakirs13468082fa_kirs
faqir17548642faq_ir_
maquis17249482maqui_s
acquire1835603acquire
acquires1945403acquires
acquits1857293acquits
affairs1334163affairs
airs46447423_a__irs
alfaquins21112243alfaquins
alfaquis2092233alfaqui_s
amirs75924923_a_mirs
aquas142412613_aqu_as
aquifers2044393_aquifers
auris55331533_a_uris
claquers19226203claquers
daiquiri1851943daiquiri
daiquiris1951593daiquiris
enquire16287213enquire
enquires17276973enquires
enquiry19254043enquiry
equids16439143_equids
equips17387193_equips
esquire16376603esquire
esquires17266213esquires
fablers124812613fablers
fabrics1436093fabrics
facers115519443fa_cers
facias113415803fa_cias
facies113921593fa_cies
factors12912123factors
fadeins1168503fadeins
faders105117463fa_ders
faeries104118993faeries
fagins10513863fa_gins
fails85631483fa__ils
fair76332523fa__ir_
fairies103516043fairies
fairy115318283fa__iry
fakeers14446673fakeers
fakers134219533fa_kers
fakir125111493fa_kir_
fallers103917993fallers
falsies103515013falsies
falters103916473falters
famulus1235043famulus
fanciers13358083fanciers
fancies124018783fancies
fanfics1535173fanfics
fanners103914653fanners
fannies103415643fannies
fanums1137263fanu_ms
farcers124713443farcers
farcies125317883farcies
farers95924053fa_rers
farmers124315263farmers
farriers113610743farriers
fascias1258413fascias
fatbird1344033fatbird
fatbirds1443413fatbirds
fathers133916503fathers
fatties103018203fatties
fatuity1336043fatuity
fatuous1037783fatuous
fauces114916153fa_uces
faulds10438963fa_ulds
faults94513553fa_ults
faunas94013633fa_unas
fauns84516753fa_u_ns
fauves125610423fa_uves
favors124211403fa_vors
favours13437093favours
favus114311733favu__s
favuses1336183favuses
fawners13388493fawners
femurs1136713femu_rs
feuars938653f_euars
fiques1837973fiqu_es
firs76637713f___irs
flairs95711913f_lairs
flirs85518933f__lirs
flours94414053flou_rs
fluids10349423f_luids
fluors94311373f_luors
fours85521493f_ou_rs
fruits94512493f_ruits
furs76735043f__u_rs
gambirs12359083gambirs
gaurs66317993ga_u_rs
hairs86225173ha__irs
inquire16227993inquire
inquires17237363inquires
inquiry19254703inquiry
jaguars1535233jaguars
kaffirs17325553kaffirs
kafirs13306983ka_firs
kauris103611533ka_uris
lacquers19125033lacquers
lairs55425873la__irs
liquids1735823liquids
liquors1634433liquors
maftirs1236043maftirs
mairs76228303ma__irs
maqui16249953maqui__
maquila1844703maquila
maquilas1944033maquilas
marquis18247063marqui_s
masquers19195703masquers
nadirs7109003na_dirs
pairs75325833pa__irs
pasquils1943123pasquils
quids154917463__quids
quins144819853__quins
quips164713373__quips
quire144917133__quire
quires154015753__quires
quirk184011003__quirk
quirks19419113__quirks
quirt144624233__quirt
quirts154213553__quirts
quits144122353__quits
requins16310203requins
require16148653require
requires17168703requires
sabirs85414633sa_birs
santirs7312963santirs
sequins1637863sequins
squibs17317453_squibs
squids16409803_squids
squire155912463_squire
squires163812843_squires
squirm17387673_squirm
squirms18376343_squirms
squirt153812933_squirt
squirts16348013_squirts
tapirs84113173ta_pirs
vairs85019133va__irs
valuers10328943valuers
vaquero1942643vaquero
vaqueros2042313vaqueros
wairs86424063wa__irs
yanquis1943723yanqui_s
zaffirs22375663zaffirs

Search took 7 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 Filter1786911340270.396451239.9
2DLD Change Limit1340271465.78023188.1
3Display Results1461460.0463173.9
 (SQL Overall)1786911466.22228719.2
 
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.