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

122 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
waitron103633(None) 
waitrons1136631waitrons
citron83112982_citron
diatron839282diatron
matron83918312ma_tron
natron64116022na_tron
patron84018042pa_tron
wanton94413812want_on
action84719683_action
aileron739833_aileron
airn46433833_ai_r_n
apron7318833_a_pron
attorn6310793_attorn
bairn77515533bai_r_n
baron78131243ba__ron
bastion9312473bastion
baton75822423ba_t_on
bicron103710773_bicron
biotron937293biotron
cairn75717513cai_r_n
caisson936593caisson
caldron1038153caldron
caltrop11267643caltrop
calutron1045553calutron
canton85722993cant_on
caption113513693caption
carton84522663cart_on
cartoon94114463cartoon
cation83925503ca_tion
caution93013523caution
chiton112612393chit_on
cistron9299883cistron
citrin82615413_citrin
citrons92913223_citrons
coition9314313coition
dacron94310693da_cron
daikon11217243dai_kon
daimon9259713dai_mon
dalton7311273dalt_on
diatrons939613diatrons
diuron738573_diuron
edition8310853edition
elytron1045463elytron
faction122613333faction
flatiron1144623flatiron
garron73113493ga_rron
gastrin839833gastrin
giron66118993_gi_ron
hadron102913753ha_dron
ignitron943203ignitron
intron64215023_intron
iron46728463__i_ron
kation104315683ka_tion
ladron73413323la_dron
macron103615673ma_cron
marron83717543ma_rron
matrons93517633ma_trons
micron103714283_micron
mikron12318503_mikron
nation64322803na_tion
natrons73215663na_trons
neutron737763neutron
niton55418283_nit_on
nitro54914353_nitro_
nitros64214123_nitros
omicron1165063omicron
omikron1353173omikron
paction112713963paction
parton84720993part_on
patrol83213023pa_trol
patrons93818103pa_trons
patroon92811973pa_troon
piton76121583_pit_on
plastron1046913plastron
pliotron1044563pliotron
positron1096903positron
ration64226013ra_tion
ratoon64417373ra_toon
ratton64116123ra_tton
rattoon7359243rattoon
sadiron836043sadiron
saffron1344173saffron
taction93213023taction
triton63914893trit_on
tuition738823tuition
waggon1136393wa_ggon
wagon94312953wa__gon
wain75840203wai___n
wair75830053wai_r__
waired106015833wai_red
wairing113414313wai_ring
wairs86424063wai_r_s
wait75553693wait___
waited103819773wait_ed
waiter94321253wait_er
waitered1238753waitered
waitering13310713waitering
waiters104218623waiters
waiting113618953waiting
waitperson1562083waitperson
waitress1135223waitress
waits88333523wait__s
wanion93213063wa_nion
wantons103713013want_ons
warison1037083warison
warn75239323wa__r_n
warren95012853wa_rren
warthog1444533warthog
warworn1357353warworn
wastrel1037553wastrel
wastrie101210303wastrie
wastry12388773wastr_y
wayworn1675293wayworn
whiten124111923whit_en
whitlow1642853whitlow
wigeon1037223w_igeon
witan83816503w_it_an
within123611383w_ithin
wittol935923w_ittol
wonton93410963wont_on
writhen13407863writhen
written10336343written

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.390458182.1
2DLD Change Limit1340271226.21621561.6
3Display Results1221220.0333697.0
 (SQL Overall)1786911226.63926915.3
 
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.