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

107 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
dicier9441623(None) 
dicer85426421dic_er
dicker134521401dicker
dickier143512451dickier
dictier103411861dictier
icier74313751_icier
airier64619362airier
bicker144819172bicker
dacker134920752dacker
decider114213182decider
decker135215992decker
decrier102713552decrier
defier105118652defier
deicer94114412deic_er
deifier113013122deifier
denier74420692denier
dewier104013462dewier
dialer74315432dialer
diaper94513112diaper
dibber114614712dibber
dice75841892dic_e_
diced95824682dic_ed
dicers94720742dic_ers
dices86434242dic_es
dicey114819332dic_ey
diciest103316522diciest
dicing105718762dicing
dicked144920862dicked
dickers144117662dickers
dickey165913522dickey
dickie133913112dickie_
dickies143416342dickies
didie74120562didie_
didies84621832didies
dieter73516772dieter
differ133910842differ
digger94616082digger
diker105524552di_ker
dimer85625602di_mer
dimmer114112612dimmer
diner65632902di_ner
dinger85323672dinger
dingier93513672dingier
dinkier123411502dinkier
dinner74217162dinner
dipper114017792dipper
dippier123111392dippier
direr64927072di_rer
dirtier83312092dirtier
dishier113613402dishier
ditcher134012002ditcher
dither104417682dither
ditsier83010292ditsier
ditzier17307962ditzier
diver94827802di_ver
divider12278952divider
diviner11369882diviner
dizzier16317542dizzier
docker134417652docker
dopier93515922dopier
dotier73917032dotier
dozier163611632dozier
drier64423962d_rier
ducker134317992ducker
duckier143911792duckier
edifier11309262edifier
icker114018442_icker
ickier12439922_ickier
jivier16438612jivier
juicier1635462juicier
kicker114116182kicker
kickier12349052kickier
lacier84020092lacier
licker125222042licker
limier83518722limier
linier64423792linier
livier97514592livier
mincier113512472mincier
mirier83918362mirier
mitier83620672mitier
nicer74618292nic_er
nicker123818702nicker
oilier64417232oilier
pacier105018682pacier
picker144422172picker
pickier153912972pickier
pinier84024692pinier
pipier104913982pipier
pitier84019822pitier
pricier113313112pricier
racier85120972racier
ribier84414232ribier
ricer74726612ric_er
richer114015042richer
rimier83916272rimier
sicker124023902sicker
sizier1514813392sizier
spicier115112462spicier
ticker124321502ticker
tidier73515112tidier
tinier63622232tinier
vinier93716742vinier
vizier184311022vizier
wicker154518672wicker
wilier93217072wilier
winier94522452winier
wirier94215552wirier

Search took 3 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 Filter178691825510.326548131.9
2DLD Change Limit825511072.45333653.1
3Display Results1071070.0462326.1
 (SQL Overall)1786911072.82563253.5
 
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.