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

116 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
animater10151239(None) 
animate91617211animate_
animated111612371animated
animaters11129951animaters
animates101316421animates
animator101410291animator
animalier1145932animalier
animately1445122animately
animato91610622animat_o
animators111210412animators
anteater8311602anteater
antimatter1245302antimatter
intimater111110572intimater
abater85518123a__bater
admitter1135113admitter
agemate101210583agemate_
agemates111110023agemates
agitate8312063agitate_
agitated1038413agitated
agitates9310873agitates
agitator946713agitator
aimer75926823a_im__er
altimeter1146613altimeter
amateur933883a__mateur
amirate91115953amirate_
amirates101114793amirates
ammeter1148393a_mmeter
ancienter1145393ancienter
anima74620073anima___
animacies1348583animacies
animacy1446103anima_cy
animadvert1652563animadvert
animal85016253anima__l
animalic1258133animalic
animaliers1244303animaliers
animally1368643animally
animals94111703anima_ls
animas84418723anima__s
animatedly1653163animatedly
animating12312503animating
animation11313683animation
animatism1348013animatism
animatist11410993animatist
anime75423203anim__e_
animes84719593anim__es
animuses1037983animuses
annates72415423an_nates
annealer845503annealer
anointer837823anointer
ansate64517863an_sate_
ansated84214003an_sated
anteaters939333anteaters
antimale10312463antimale_
antimatters1354333antimatters
aviate9315203avi_ate_
aviated11310263avi_ated
aviates10313063avi_ates
aviator10229663avi_ator
avigator12236763avigator
bandmaster15124413bandmaster
bandmate1347973bandmate_
bandmates1447923bandmates
banister10199973bani_ster
canister101710853cani_ster
climate11312833climate_
climates12311963climates
dilater83515643_dilater
dimeter10411893_dimeter
exanimate1845663exanimate_
ganister9178993gani_ster
grimacer1363963grimacer
imager9108123__imager
inanimate1146993inanimate_
inflater1149893inflater
inmate82917353in_mate_
inmates92715763in_mates
intimate101013823intimate_
intimated121010883intimated
intimaters1297853intimaters
intimates111013303intimates
irater65218343__irater
knitter11348133kni_tter
limiter92710853_limiter
manometer1368763manometer
mater74438863___mater
nanometer1167783nanometer
narrater838723narrater
neater64424313_n_eater
negater83711953_negater
nidate7313783_nidate_
nidated939863_nidated
nidates8311883_nidates
nimbler11358063_nimbler
niter55028973_ni__ter
oximeter1755153oximeter
planimeter1443803planimeter
primate111516283primate_
primates121515933primates
privater13158533privater
rainmaker1544383rainmaker
rainwater1244573rainwater
reanimate1148083reanimate_
reanimated1347003reanimated
reanimates1247843reanimates
salimeter1157373salimeter
sanitate8612043sanitate_
sanitated1068993sanitated
sanitates9611733sanitates
scimiter1236143scimiter
snifter10349623sni_fter
taximeter1844413taximeter
trimeter10310083trimeter
uniter64619143uni__ter
unmaker13279513un_maker
unmated103317023un_mated
unmiter9310393un_miter

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.1561145455.1
2DLD Change Limit1461621167.50019488.3
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.70223200.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.