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 “hexer” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 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
hexer15511668(None) 
heder95623641heder
hewer115719931hewer
hexed165615761hexed
hexers165612751hexers
hexes155123041hexes
vexer155513521vexer
beer65635992be_er
boxer145016522boxer
ceder85322242ceder
cheder125113492cheder
cheer105420382che_er
chewer145512622chewer
deer56739022de_er
defer94619752defer
deter65028042deter
dexes135224512dexes
dexter143810892dexter
eger55923572_eger
ever77027692_ever
ewer77523982_ewer
exec135313942_exec
exed125420592_exed
exert124624142_exert
exes116530812_exes
eyer76127282_eyer
fever115617952fever
fewer115216122fewer
feyer115014522feyer
fixer154717832fixer
haler85033522haler
hater85034752hater
haver115124462haver
hayer114620242hayer
hazer174820232hazer
header104422542header
healer94221802healer
heaper114119522heaper
hear76143882he_ar
hearer94323642hearer
heater94828302heater
heaver124819672heaver
hebe96424702hebe_
hebes105521672hebes
heders104119762heders
hedger114912652hedger
heed86437602he_ed
heeder104216042heeder
heel75034222he_el
heeler93917312heeler
hefter124313922hefter
heifer1238202heifer
heir77523802he_ir
heller93322512heller
helper114313092helper
heme95034412heme_
hemes105031082hemes
hemmer134112642hemmer
hepper133412662hepper
her66547812h__er
herder104516462herder
here76447102here_
heres86245902heres
hetero9312632hetero
hewed125619432hewed
hewers123715272hewers
hex137436172hex__
hexad164910622hexad
hexerei1764162hexerei
hexyl1844462hexyl
hider95024082hider
hiker125119392hiker
hirer85423122hirer
hoaxer16348562hoaxer
hoer76533982h_oer
homer105828452homer
honer85332092honer
hoper105829142hoper
hoser811529762hoser
hover115524132hover
huger94914872huger
hyper135213902hyper
jeer115426462je_er
kexes166216822kexes
laxer125420332laxer
leer46239352le_er
leger65721512leger
leper74820742leper
lever85125162lever
lexes127225262lexes
merer75126232merer
meter75130322meter
mixer145017642mixer
never86218642never
newer85717462newer
peer66238352pe_er
peter74427592peter
refer84822142refer
rexes124526952rexes
seder64826762seder
seer45547042se_er
serer55935512serer
sever85426052sever
sewer84426222sewer
sexed136618542sexed
sexes126126222sexes
sexier13310682sexier
sheer84726892she_er
shewer124515112shewer
taxer125019362taxer
veer76229572ve_er
vexed165713112vexed
vexers165210402vexers
vexes155719122vexes
waxer154317482waxer
weber10313522weber
weer75535092we_er

Search took 2 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 Filter178691538000.330541487.9
2DLD Change Limit538001171.57634137.1
3Display Results1171170.0333545.5
 (SQL Overall)1786911171.93992156.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.