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

126 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
milker12481432(None) 
bilker124913441bilker
milder93818451milder
miler75733061mil_er
milked134612571milked
milkers134411611milkers
milkier133411161milkier
miller84625411miller
milter84921231milter
mirker123712691mirker
balker124519162balker
bicker144819172bicker
biker116022562bi_ker
bilked134012942bilked
bilkers134711862bilkers
biller84923482biller
calker124917082calker
dicker134521402dicker
diker105524552di_ker
filer85433002fil_er
filler94623622filler
filmer114112402filmer
filter94517632filter
gilder84415532gilder
giller74519732giller
hiker125119392hi_ker
hiller94421632hiller
icker114018442_icker
iller54821292_iller
inker94421092_inker
jilter133512512jilter
jinker174013542jinker
kicker114116182kicker
killer104917952killer
kilter103714342kilter
licker125222042licker
liker95627062li_ker
linker104321472linker
mailer84724182mail_er
maker114127812m_aker
marker124420392marker
masker124416102masker
meeker12359982meeker
melder93915812melder
melter83520112melter
mickey174211852mickey
mickler153310232mickler
mike105535292mi_ke_
miked125020452mi_ked
mikes115129892mi_kes
milded104416152milded
milden94113152milden
mildew12319042mildew
mile66352572mil_e_
milers84625162mil_ers
miles74645072mil_es
milieu8314112milieu
milk105028472milk__
milkmen1565212milkmen
milks115020582milk_s
milky144014442milk_y
mille75029132mille_
milled94326172milled
millers93621342millers
milles84526562milles
millet84030742millet
millier93716702millier
milneb1095952milneb
milted93919942milted
milters93619092milters
miltier93214962miltier
mimer94825762mi_mer
mincer104017362mincer
minder94822502minder
miner76933542mi_ner
minke115421762minke_
minkes124618782minkes
minter84425102minter
mirier83918362mirier
mirkier13319052mirkier
miser75430402mi_ser
misliker14319572misliker
mister84728562mister
miter75734792mi_ter
mither114218562mither
mitier83620672mitier
mixer145017642mi_xer
mocker143315442mocker
moiler84017262moil_er
molder93819272molder
molter84119422molter
mucker143816392mucker
muller83820352muller
murker123715242murker
nicker123818702nicker
oiler54628282oil_er
oilier64417232oilier
picker144422172picker
piker115622842pi_ker
pilfer1139162pilfer
pinker125322442pinker
risker105414492risker
sicker124023902sicker
siker95326032si_ker
silked114314812silked
silken104410852silken
silkier114411642silkier
siller64026062siller
silver93815812silver
sinker103620902sinker
smiler83916682smil_er
smirker13327422smirker
sulker104015922sulker
talker103916222talker
ticker124321502ticker
tiler56131022til_er
tiller64222542tiller
tilter63417692tilter
tinker103619922tinker
viler86324162vil_er
walker133913992walker
wicker154518672wicker
wilder103616472wilder
wilier93217072wilier
willer94021062willer
winker134220292winker

Search took 4 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.343520965.0
2DLD Change Limit825511263.00027517.0
3Display Results1261260.0761657.9
 (SQL Overall)1786911263.41952264.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.