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

156 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
batterie1071153(None) 
batteries11615111batteries
bacteria1248982bacteria
bacterin12410272bacterin
bacterize2247652bacterize
batter84928872batter__
battered113315052battered
batterer102713212batterer
battering122715142battering
batters94626012batter_s
battery124911812batter_y
butterier1177452butterier
butteries11711762butteries
catteries11815522catteries
hatteria1137862hatteria
wasterie111211582wasterie
absterge1154083absterge
aerie54634603_a__erie
apteria9312913_apteria
arteries8321483_arteries
asteria7316183_asteria
attire62412383_attir_e
attrit6315753_att_rit
attrite7311833_att_rite
bacterial1348363bacterial
bacterias1349283bacterias
bacterins13410643bacterins
bacterium1546673bacterium
bacterized2446283bacterized
bacterizes2347963bacterizes
bacteroid1456253bacteroid
baiter84422553baiter__
baiters94619303baiter_s
bakeries14312193ba_keries
banter84825333banter__
bantered113313633bantered
banterer102811773banterer
bantering122414233bantering
banters94623113banter_s
barter85525373barter__
bartered113113013bartered
barterer102711633barterer
bartering122313643bartering
barters94223033barter_s
baster85333593baster__
basters94930303baster_s
bather115322513bather__
bathers124720363bather_s
bathetic1548583bathetic
battalia1045293battalia
batteau936343batte_au
batteaux1742503batteaux
batted95623653batte__d
batten85217123batte__n
battened11259573battened
battener10369393battener
battening12268853battening
battens95313263batte_ns
batterers113110713batterers
battier93515713batt__ier
battik1238093batt__ik
battle85217863batt__le
battler94113383battler__
battlers104110973battler_s
battue84311003batt__ue
bawtie113812143bawt__ie
better84723703better__
bettered113011833bettered
bettering122212753bettering
betters94422093better_s
bitter84622673bitter__
bittered112711833bittered
bitterer10309773bitterer
bittering122511993bittering
bitterish1446133bitterish
bitterly1335603bitterly
bittern94810683bitter_n
bitterns10428953bitterns
bitters94920363bitter_s
blatter94415653blatter__
blattered12198563blattered
blattering13108713blattering
blatters104414093blatter_s
boiserie1047993boiserie
booteries11312773booteries
brasserie1145323brasserie
butleries11710073butleries
butter84724233butter__
buttered112712623buttered
butteriest1276883butteriest
buttering122312523buttering
butters94521723butter_s
buttery124311193butter_y
cattery123811603catter_y
cattie85221023catt__ie
causerie1078273causerie
cauteries11615393cauteries
cauterize2088313cauterize
coterie9417403_coterie
eateries8324313ea_teries
faerie93514683fa__erie
fatter94523213fatter__
flatteries1347413flatteries
haltere103614703halter_e
hatter94724873hatter__
hatterias1258743hatterias
hatters104221523hatter_s
jitterier1644433jitterier
laterite8716333la_terite
laterize17613293la_terize
latter65027893latter__
latterly1136063latterly
lotteries9311073lotteries
masteries111018493masteries
materiel10311253ma_teriel
matter84325343matter__
mattered112412903mattered
mattering122314053mattering
matters94421753matter_s
mattery123810713matter_y
natter64420743natter__
nattered92011623nattered
nattering102212213nattering
natters73718063natter_s
niterie7313743_niterie
papeterie1345193papeterie
parterre1036983parterre
pattee84323383patte__e
patter84628263patter__
pattered112714203pattered
patterer103112173patterer
pattering122314423pattering
pattern93712053patter_n
patterned1265743patterned
patterns10439943patterns
patters94825193patter_s
pattie84020963patt__ie
potteries11313593potteries
ratter64326313ratter__
ratters74422473ratter_s
santeria8311653santeria
sauterne846253sauterne
tatter64024573tatter__
tattered92011443tattered
tattering102212323tattering
tatters74520483tatter_s
tattie64817513tatt__ie
trattorie944963trattorie
wasteries121115343wasteries
wastrie101210303wast_rie
waterier11312083wa_terier
watter93221983watter__
yatter94116213yatter__
yattered12239533yattered
yattering132410443yattering
yatters103914623yatter_s

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.436409841.7
2DLD Change Limit1461621567.39019778.3
3Display Results1561560.0632476.2
 (SQL Overall)1786911567.88922650.7
 
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.