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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
dirge7511707(None) 
dinge75627301dinge
dire56644151dir_e
dirges84915101dirges
barge85631022barge
bilge87618912bilge
binge85125512binge
birle75023632birle
birse74517402birse
cire65836382cir_e
dare55848862dar_e
dere56845902der_e
dice75841902di_ce
didie74120572didie
die46759662di__e
diene65720132diene
dig57544482di_g_
digged104314652digged
digger94616082digger
digs66036062di_gs
dike95935772di_ke
dime76237652di_me
dine55555342di_ne
ding66940962ding_
dinged95221782dinged
dinger85323672dinger
dinges83825422dinges
dingey114914052dingey
dingle84317072dingle
dingo74720792dingo
dings76331402dings
dingy105721262dingy
diode74716122diode
diram84419472diram
direr64927072direr
dirk96326842dir_k
dirked124912272dirked
dirks105619522dirks
dirl57430032dir_l
dirled84514902dirled
dirls64720502dirls
dirt55550392dir_t
dirts66824462dirts
dirty95617802dirty
disme85716242disme
dite55547562di_te
dive85634782di_ve
diverge12347642diverge
dodge86618132dodge
doge66233802d_oge
dore56353302dor_e
dree56638322d_ree
dreg66821652d_reg
drive95318002drive
dure56341812dur_e
fidge104516072fidge
fire76245602fir_e
forge95126942forge
gorge76423892gorge
gurge75419782gurge
hinge95323452hinge
hire75538972hir_e
hiree85427802hiree
ire36943182_ir_e
large65325462large
liege65314432liege
lire47845302lir_e
marge85328332marge
merge84523692merge
midge95016562midge
mirage92313652mirage
mire66748242mir_e
parge85831852parge
purge85324602purge
ridge75018682ridge
sarge65531132sarge
serge64727472serge
siege66718442siege
singe65731132singe
sire46150422sir_e
siree55238812siree
surge65027692surge
targe65227102targe
tinge64626632tinge
tire46143362tir_e
urge54722422_urge
verge93419842verge
virga9310252virga
wire75839822wir_e

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.313570897.8
2DLD Change Limit53800891.47036598.6
3Display Results89890.0302966.7
 (SQL Overall)178691891.81398560.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.