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

149 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
wiselier113736(None) 
wifelier1434851wifelier
gaselier946962gaselier
likelier1235282likelier
livelier1136872livelier
timelier1036712timelier
wielder11197672wi_elder
wieldier1234282wi_eldier
wigglier1354452wigglier
wilier93217072wi__lier
wiseliest1237722wiseliest
wispier12249402wis_pier
atelier7311633_atelier
baseliner1144743baseliner
belier84423563__belier
bristlier1144313bristlier
chiseler1335903chisel_er
chiseller1443973chiseller
cicelies1269753cicelies
comelier12310653comelier
costlier1038523costlier
dimplier1336673dimplier
disbelief1545503disbelief
dishier113613403dis_hier
disliker13358643dis_liker
dispeller12146983dispeller
eelier64216463__eelier
fielder11217413fi_elder
fierier103511193fi_erier
fishier13359853fis_hier
fusilier1135433fusilier
gasalier936443gasalier
gaseliers1044933gaseliers
gasolier935833gasolier
gigglier1154323gigglier
girlier8289523gi_rlier
grislier935793gris_lier
gristlier1044283gristlier
hillier103413963hi_llier
hissier103410503his_sier
homelier1338983homelier
hotelier1137633hotelier
inlier63615363_i_nlier
jigglier1754093jigglier
jinglier1655233jinglier
kindlier1345763kindlier
kinglier1345633kinglier
libeler9219003libel_er
libeller10297433libeller
lonelier838003lonelier
lovelier1136433lovelier
millier93716703mi_llier
misalter1038343misalter
misbelief1645193misbelief
misenter10310833misenter
miseries10320403miseries
mislie83219153mis_lie_
mislies92922283mis_lies
misliker14319573mis_liker
misrelied1247243misrelied
misrelies1149723misrelies
mistier93418713mis_tier
nigglier1044843nigglier
oilier64417233oi__lier
pimplier1445413pimplier
pistolier1146383pistolier
relier65826183__relier
reseller83412253reseller
ripplier1234463ripplier
riskier1138423ris_kier
seller63824603__seller
sexier13310683__sexier
sicklier1457213sicklier
sideliner10126013sideliner
sillier74017593si_llier
sissier73711363sis_sier
slier54827243__s_lier
steelier839193steelier
swirlier1135213swi_rlier
swishier1434563swis_hier
thistlier1243653thistlier
tinglier956403tinglier
tinklier1255443tinklier
twiddlier1441863twiddlier
twirlier1133513twi_rlier
twistier1134813twis_tier
viewier1334983vi_ewier
viselike1536923viselike
wabblier15375493wabblier
wafflier1733953wafflier
wagglier1344323wagglier
wamblier15275733wamblier
washier133611153was_hier
waspier12259053was_pier
waterier11312093waterier
weaklier1534263weaklier
weedier113810623w_eedier
weenier103210803w_eenier
weepier12319273w_eepier
welder102914413w__elder
welter93417383w__elter
wheeler13298783wheel_er
wheelie1336203wheelie_
wheelies1437873wheelies
wheezier2333353wheezier
whelkier1833263w_helkier
whirlier14175293whirlier
whistler1496313whistl_er
widener11318693wide_ner
wielded12216683wi_elded
wielders12196613wi_elders
wiener94513543wi_e_ner
wienie9229973wi_enie_
wienies102213683wi_enies
wifeliest1545883wifeliest
wifelike18135253wifelike
wiftier13297733wi_ftier
wiggier12418863wi_ggier
wiggler123110763wiggl_er
wilder103616473wi__lder
willer94021063wi__ller
willie94116453wi_llie_
willied114611563wi_llied
willies103920153wi_llies
wimpier14248053wi_mpier
windier113412163wi_ndier
wineries112316533wineries
wingier113413283wi_ngier
winier94522453wi__nier
winterier1238343winterier
wintrier1136873wintrier
wirelike15167493wirelike
wirier94215553wi__rier
wiseacre1343013wiseacre
wisely122711713wisel__y
wiser85522803wis___er
wisher123617063wis__her
wisplike1734713wisplike
witchier16307883witchier
withier132910493wi_thier
wittier103910823wi_ttier
wobblier15325203wobblier
woolier103612353w_oolier
woollier1155433woollier
wrigglier1462413wrigglier
wrinklier1643013wrinklier
wristier1136863wris_tier
wussier10408083wus_sier
yielder11175113yi_elder

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 Filter1786911461620.576310227.4
2DLD Change Limit1461621497.22020244.0
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.85922737.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.