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

114 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
waitrons113664(None) 
waitron1036331waitron_
citrons92913222_citrons
diatrons939622diatrons
matrons93517632ma_trons
natrons73215662na_trons
patrons93818102pa_trons
waitress1135222waitress
wantons103713012want_ons
actions94218513_actions
ailerons849853_ailerons
airns55521033_ai_r_ns
aprons8316993_a_prons
attorns738443_attorns
bairns86710873bai_r_ns
barons85025383ba__rons
bastions10411693bastions
batons85519423ba_t_ons
baudrons1135763baudrons
bicrons113410473_bicrons
biotrons1037243biotrons
cairns85313303cai_r_ns
caissons1036283caissons
caldrons1138063caldrons
caltrops12307863caltrops
calutrons1145503calutrons
cantons95221203cant_ons
captions123813223captions
cartons94122473cart_ons
cartoons104012803cartoons
cations94524143ca_tions
cautions103313183cautions
chitons122611913chit_ons
cistrons102710643cistrons
citrins92614363_citrins
citron83112983_citron_
citrous93112993_citrous
coitions10312853coitions
dacrons103211033da_crons
daikons12186693dai_kons
daimons10249323dai_mons
daltons8310403dalt_ons
diatron839283diatron_
diurons838823_diurons
editions9310403editions
factions133013063factions
flatirons1244483flatirons
garrons82713463ga_rrons
gastrins9310133gastrins
girons75014373_gi_rons
goitrous945763goitrous
hadrons113314303ha_drons
ignitrons1042993ignitrons
introns73515023_introns
irons55324133__i_rons
kations114013663ka_tions
ladrons83813193la_drons
macrons113514893ma_crons
marrons93216973ma_rrons
matron83918313ma_tron_
microns113814783_microns
mikrons13428413_mikrons
nations74720563na_tions
natron64116023na_tron_
neutrons838293neutrons
nitons64614903_nit_ons
nitros64214123_nitro_s
nitrous73512493_nitrous
omicrons1275193omicrons
omikrons1462963omikrons
pactions122613503pactions
partons94620513part_ons
patrols93513513pa_trols
patron84018043pa_tron_
patroons102710603pa_troons
pitons85319043_pit_ons
plastrons1147133plastrons
pliotrons1144713pliotrons
positrons1186543positrons
rations74123433ra_tions
ratoons73815473ra_toons
rattons73815323ra_ttons
rattoons8327513rattoons
sadirons936033sadirons
saffrons1444303saffrons
tactions102912423tactions
tritons73814883trit_ons
tuitions838283tuitions
waggons1235503wa_ggons
wagons103911213wa__gons
wains86930873wai___ns
wairing113414313wai_ring
wairs86424063wai_r__s
waitering13310723waitering
waiters104218623wait_ers
waiting113618953wait_ing
waitings123413743waitings
waitpersons1672093waitpersons
waits88333523wait___s
wanions104011373wa_nions
wanton94413813want_on_
warisons1136903warisons
warns87231003wa__r_ns
warrens103810893wa_rrens
warthogs1544833warthogs
wastrels1136203wastrels
wastries111212883wastries
whitens13428733whit_ens
whitlows1743093whitlows
wigeons1136983w_igeons
witans93412933w_it_ans
withins133511693w_ithins
wittols1035733w_ittols
wontons103310533wont_ons

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 Filter1786911461620.470380193.6
2DLD Change Limit1461621147.37619815.9
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.89222642.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.