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 “loquats” 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.

153 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
loquats164527(None) 
loquat1558281loquat_
coquets18399892coquets
diquats1745972diquats
liquate1638412liquate
liquates1737442liquates
locusts9277932locusts
loggats9286452loggats
louts56330272lo_u_ts
lovats939072lo_vats
roquets16398942roquets
squats153712962_squats
toquets16367862toquets
acquits1857293acquits
aliquots1743643aliquots
aquas142412613_aqua_s
bloats85215763blo__ats
boats75635153bo__ats
bobcats1335993bobcats
bosquets19195253bosquets
bouquets19244523bouquets
bouts75131313bo_u_ts
cloques18268563cloqu_es
clouts87017203clo_u_ts
coats75634993co__ats
coequals1944303coequals
coequate1946153coequate
coequates2045843coequates
combats13311683combats
coquet174318013coquet_
coquito1845403coquito
coquitos1944703coquitos
counts84618273co_unts
courts84216163co_urts
cowpats1437713cowpats
croquets1955213croquets
cumquats2142833cumquats
diquat1639763diquat_
doats65224883do__ats
donuts7410583donu_ts
doubts968733do_ubts
equals1538693_equals
equate152012463_equate
equates162012313_equates
floats96816253flo__ats
floruits1145153floruits
flouts94315273flo_u_ts
formats123113573formats
founts94313383fo_unts
gloats74515423glo__ats
glouts74414713glo_u_ts
goats65527303go__ats
gouts64826173go_u_ts
jouals1338923jo_uals
jousts135011273jo_usts
korats105416063ko_rats
kumquats2341723kumquats
lariats7615053lariats
lats45962703l___ats
lauans65113533l_auans
lehuas935943lehua_s
liquated1835483liquated
liquids1735823liquids
liquors1634433liquors
loads65323373lo__ads
loafs85616993lo__afs
loams75619863lo__ams
loans56026463lo__ans
loath84918603lo__ath
lobate82915243lo_bate
lobulate1078833lobulate
lobules92510813lobules
locals83714503lo_cals
locate83919843lo_cate
locates93218813lo_cates
lochans1248833lochans
lockets134612203lockets
loculate101011403loculate
locules92812603locules
loculus9296973loculus
locums10478303locu_ms
locus74819993locu__s
locust85312343locust_
locusta9326533locusta
lofts85518363lo__fts
logans76319063lo_gans
loggets9378913loggets
logjams1743583logjams
logways1434513logways
loments93413473loments
longans84510813longans
loofahs13364623loofahs
loofas9429833loofa_s
loots55431423lo__ots
loquacity2342483loquacity
lorans65117603lo_rans
lotahs9479873lo_tahs
lotas55926303lo_ta_s
lots47652093lo___ts
lotus55718063lotu__s
lotuses74011253lotuses
loughs105014773lo_ughs
louies64525103lo_uies
louis57322323lo_u_is
loumas84812333lo_umas
loupes84918053lo_upes
loups75319623lo_u_ps
lours55125293lo_u_rs
louses66230283lo_uses
lout45952143lo_u_t_
lovat8321043lo_vat_
luaus54514903l__uaus
lunts55826903l__unts
lusts55022803l__usts
moats75827643mo__ats
moults84713703mo_ults
mounts84115073mo_unts
nougats8427413nougats
oats46554213_o__ats
oquassa1642063_oquassa
ousts55225703_o_usts
outs45746963_o_u_ts
piquets1836603piquets
poults84613483po_ults
pouts75530323po_u_ts
qats135331343__q_ats
quads154515843__quads
quags154613253__quags
quais144618393__quais
quants153614143__quants
quarts154715933__quarts
quass144413763__quass
quate144521413__quate
quays174612043__quays
quits144122353__quits
roques154912563roqu_es
roquet154415893roquet_
rorquals1773173rorquals
rousts617016723ro_usts
routs57133413ro_u_ts
squabs17429323_squabs
squads164410293_squads
squat143720143_squat_
squaws18438783_squaws
toluate7159343toluate
toluates8138893toluates
tomcats11127773tomcats
toques154612353toqu_es
toquet154414683toquet_
torquate1745003torquate
touts54830393to_u_ts
wombats1435893wombats
yogurts1142983yogurts

Search took 8 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.1561145455.1
2DLD Change Limit1340271537.50017870.3
3Display Results1531530.0801912.5
 (SQL Overall)1786911537.73623098.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.