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

125 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
derrick143580(None) 
derricks1544431derricks
defrock1744642defrock
dermic114511912dermic_
derries83124622derries
derris73615272derri_s
detick1339382de_tick
dornick1435272dornick
ferric1139992ferric_
airsick1395333airsick
arrack121110253_arrack
barrack1538253barrack
bedrock1645643bedrock
bedtick1645233bedtick
berried103714043berried
berries94423553berries
brick134618153__brick
carrack1548753carrack
carsick1536343carsick
ceric94023093ce_ric_
crick135118753__crick
daric85623113d_aric_
darics94314113d_arics
dearie73319813deari_e
dearies83526273dearies
debride1138593debride
debrief1337623debrief
debris93311493debri_s
deck115827753de___ck
decrial10310323decrial
decried112612853decried
decrier102713553decrier
decries103319803decries
defrocks1844113defrocks
deice84320033de__ice
deific1237313deific_
delict94320333de_lict
deltic9312503deltic_
demic105119193de_mic_
depict113514793de_pict
deprive1338303deprive
deraign936573deraign
derail74218813derai_l
derails84216393derails
derbies103016053derbies
derelict11138483derelict
deride84420033de_ride
derive103817043de_rive
dermis94717163dermi_s
dernier83011943dernier
derriere936043derriere
derrises93012783derrises
derry94721373derr__y
dervish1436983dervish
deticks1437353de_ticks
detract101414633detract
device124512163de_vice
devoice13347343devoice
dick116432383d___ick
dormice1237133dormice
dorneck1444303dorneck
dornicks1544403dornicks
dornock1444403dornock
dreck124812803d__reck
dreich12377723d_reich
drink106816383d__rink
durrie73713263durri_e
durries83817353durries
enrich1138943_enrich
erica7316543_e_rica
erring73816483_erring
ferried113411523ferried
ferries103521083ferries
ferrite103312753ferrite
hayrick1944183hayrick
herdic123112303herdic_
herdics13249523herdics
heroic113516923heroic_
heroics122912003heroics
herried113514453herried
herries104025073herries
herring113615883herring
jerrican1794123jerrican
jerrid14259143jerri_d
jerrids15277743jerrids
jerries143817513jerries
kerria10339913kerri_a
kerrias11289513kerrias
kerries113317913kerries
medick154010133me_dick
merrier92612303merrier
merrily1238633merrily
metric10314673metric_
metrics11312363metrics
orrice81410163_orrice
overrich1648453overrich
oversick1736983oversick
overtrick1865833overtrick
perries93226603perries
prerock1536723prerock
prick134317503__prick
redbrick1742653redbrick
reprice113212833reprice
rerack122513163re_rack
retrack131310723retrack
rick107334653___rick
seasick1346193seasick
serried82513963serried
serries73925353serries
service1239093service
strick124813203_strick
terbic10410963terbic_
terrace93311843terrace
terrier73414963terrier
terries73425633terries
terrify1336353terrify
terrine72517573terrine
territ63421373terri_t
territs72714503territs
trick115420693__trick
undertrick1754143undertrick
verdict1339583verdict
verruca1243713verruca
wrick144013393__wrick
xeric144315663xe_ric_

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271256.71619956.4
3Display Results1251250.0502500.0
 (SQL Overall)1786911257.17224915.1
 
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.