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

110 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
irade6561815(None) 
grade75126091grade
irades74517391irades
irate55627981irate
tirade7311691tirade
trade65026041trade
abrade9313052abrade
arame75026622arame
arcade91013642arcade
bade75140892_bade
barde85330772barde
blade85923332blade
brace95629272brace
brad75234342brad_
brads85528292brads
brae65639112bra_e
brake116025342brake
brave104925502brave
braze165423452braze
brede85520502brede
bride86425542bride
cade76443922_cade
clade85821012clade
cradle93313162cradle
crake114823522crake
crane75331602crane
crape96128442crape
crate76537402crate
crave105626312crave
craze165221462craze
crude86018572crude
drake104918302drake
drape85319632drape
drave95219272drave
erase54925492erase
erode64520992erode
evade938182evade
fade85736352_fade
frae75330472fra_e
frame105821802frame
glade75121962glade
grace85124542grace
grad66829862grad_
graded94919552graded
grader84919692grader
grades84926312grades
grads75625752grads
grape84824662grape
grate64932882grate
grave94624872grave
graze155820052graze
gride75223592gride
hade85440202_hade
image81411292image
imide85716902imide
inane52820342inane
invade10157852invade
irater65218352irater
ire36943182ir__e
ired55131872ired_
irid55927182irid_
irides74519122irides
irids66417782irids
irked104510922irked
irone55126362irone
jade125325452_jade
lade56345992_lade
made75440252_made
mirage92313652mirage
orad56031692orad_
orate55133302orate
parade94720642parade
pirate82322882pirate
prase76128752prase
prate75135982prate
pride84724742pride
prude84615972prude
race66746262_race
rad47662012_rad_
rads56046612_rads
rage55742352_rage
rake84841572_rake
rale45050562_rale
rape65041632_rape
rare45348432_rare
rase46149982_rase
rate45458762_rate
rave75542092_rave
raze135235432_raze
rede55037682_rede
ride55945142_ride
rode55844312_rode
rude55632792_rude
sade55544482_sade
shade95125582shade
spade84423322spade
stade64825302stade
tirades8311722tirades
trace75829612trace
trad55630912trad_
traded85717682traded
trader75218762trader
trades75724502trades
trave85223032trave
trode65322852trode
tsade64311122tsade
urare56322552urare
urase54624692urase
urate55432162urate
wade85237072_wade

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.343520965.0
2DLD Change Limit538001101.48336277.8
3Display Results1101100.0333333.3
 (SQL Overall)1786911101.85996122.1
 
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.