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

128 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
anointer83782(None) 
anointed938341anointed
anointers937001anointers
ancienter1145392ancienter
anoint6423632anoint__
anoints7311062anoint_s
appointer1354422appointer
arointed939002arointed
cointer93616722_cointer
jointer14379712_jointer
pointer93814932_pointer
aborter939933abo_rter
absenter1086773absenter
aconite9315473aconite_
aconites10314353aconites
admitter1135113admitter
adopter1036763ado_pter
adorner8246983adorn_er
adroiter946193adroi_ter
aginner844663a_ginner
aglitter935093aglitter
aliner65621983a_lin_er
amounted1135533amounted
andante8311273andante_
andantes9310853andantes
animater101512393animater
announcer1143293announcer
anointing1038623anointing
anointment1256463anointment
anolyte10159003anolyte_
anolytes11169213anolytes
another10289153ano_ther
anteater8311603anteater
antihunter1353863antihunter
antinuker1344473antinuker
antiquer1746873antiquer
appointed1444803appointed
appointee1345003appointee
appointers1443763appointers
appointor1342893appointor
arbiter939933arbi_ter
aroint6328153aroint__
aroints7313133aroint_s
aroynted1244523aroynted
assenter867703assenter
assister836753assister
atoner64817193ato_n_er
atwitter1143673atwitter
avoider1155813avoi_der
awaiter1057443awai_ter
banister10199973ban_ister
bannister1155373bannister
canister101710853can_ister
cannister1155723cannister
canonizer2046693canonizer
cloister1037093cloister
coiner84323783_coin_er
coinfer12419393_coinfer
cointers103616413_cointers
counter94220153_counter
disinter9310673disinter
eloiner7149183eloin_er
encounter1145183encounter
engineer945493engineer
enjoinder1742723enjoinder
enjoiner15225653enjoin_er
enlister847803enlister
fainter103611053_fainter
fronter103611583fro_nter
ganister9178993gan_ister
gannister1054173gannister
goiter74116203_goi_ter
hinter94021303__hinter
hoister103714203_hoister
incenter102212093incenter
inciter93113773inci_ter
indenter92311443indenter
indicter1148143indicter
inditer83514233indi_ter
insister888783insister
inter55028493___inter
inventer112410843inventer
inviter104112313invi_ter
joinder15337593_joinder
joiner134114133_join_er
jointed15378503_jointed
jointers15289323_jointers
knitter11348133kn_itter
knotter11317643kno_tter
knowinger1741913knowinger
linter64625343__linter
loiter64619173_loi_ter
manometer1368763manometer
minter84425103__minter
misinter1038833misinter
moister94015373_moister
mounter93713173_mounter
nanometer1167783nanometer
niter55028973_n_i_ter
noisier759453_noisier
noter55025643_no__ter
painter93814563_painter
pointe84619313_pointe_
pointed103813983_pointed
pointers103013723_pointers
pointes93216753_pointes
pointier1038303_pointier
printer93917303_printer
quainter1765903quainter
reanointed1144553reanointed
reinter73116843_reinter
roister73516203_roister
sinter63625923__sinter
snifter10349623sn_ifter
snorter74412663sno_rter
splinter10329703splinter
sprinter103810813sprinter
squinter1747363squinter
stinter73614513_stinter
tinter63923643__tinter
unbitter1046173unbitter
uniter64619143un_i_ter
unjointed1755583unjointed
unkinder1335363unkinder
unmiter9310393unmi_ter
unpointed1237153unpointed
unwinder1235613unwinder
winter94222803__winter

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.420425454.8
2DLD Change Limit1461621286.89321204.4
3Display Results1281280.0462782.6
 (SQL Overall)1786911287.35924282.0
 
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.