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

176 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
lingerer911830(None) 
fingerer12127221fingerer
lingered10129641lingered
lingerers10126921lingerers
fingered13128332fingered
fingerers13136302fingerers
gingered11127742gingered
hinderer1238272hinderer
limberer12187052limberer
linger75226002ling__er
lingerie959202lingerie
lingeries10511812lingeries
lingers84223302linger_s
lingier84113382ling_ier
litterer82810172litterer
malingerer1342172malingerer
sincerer1037202sincerer
tinkerer1286802tinkerer
winterer112110442winterer
angered93013473_angered
banterer102811773banterer
bickerer16106773bickerer
binger94923453bing__er
bingers104519993binger_s
bitterer10309773bitterer
blinkered1644413blinkered
blunderer1244543blunderer
cindered1239793cindered
cipherer1545573cipherer
clinger103812153cling__er
clingers113810663clinger_s
clingier1155853cling_ier
clinkered1634773clinkered
congener112412203congener
dangered11248513dangered
dinger85323673ding__er
dingers94321383dinger_s
dingier93513673ding_ier
ditherer12187763ditherer
eagerer8248823_eagerer
enterer72015633_enterer
fidgeter1343783fidgeter
figurer11215863fi_gurer
filterer11258143filterer
finger104920333fing__er
fingers113418433finger_s
flinger113710513fling__er
flingers123410193flinger_s
gingeley13294673gingeley
ginger84920033ging__er
gingerly13315303gingerly
gingers94118643ginger_s
gingery12368913ginger_y
hankerer15248233hankerer
hindered1339453hindered
hinderers1337353hinderers
hinger104723333hing__er
hingers113420213hinger_s
hungered13217053hungered
ignorer8276103_ignorer
indexer15287253_indexer
inferrer11217443_inferrer
inhere9313713_inhere_
inhered11313163_inhered
inheres10315173_inheres
injurer14318473_injurer
inserter82312133_inserter
insurer73312803_insurer
integer837993_integer
inverter112411073_inverter
jiggered1834203jiggered
jingler154311093jing_ler
jinglier1655233jinglier
kinglier1345633kinglier
kipperer16294723kipperer
laagered1055853laagered
lagered92311153l_agered
langrel8107033lang_rel
lanneret82512363lanneret
latherer111310453latherer
launderer1094513launderer
letterer8259223letterer
libeler9219003li_beler
lieder74912323li__eder
liefer9529573li__efer
liegemen1144133liegemen
liever94611863li__ever
liger65024473li_g__er
ligers75022043li_ger_s
lighter113113443li_ghter
ligure7279473li_gure_
ligures8269893li_gures
limbered13158123limbered
linear65113343lin_e_ar
linebred1144963linebred
linemen938633lin_emen
liner55938923lin___er
liners65428853lin_er_s
lingberry1542313lingberry
lingering11310513lingering
lingoes84014693ling_oes
linguae8398413linguae_
lingular9407503lingular
linier64423793lin__ier
linker104321473lin__ker
linkers114317713linker_s
linseed838203linse_ed
linter64625343lin__ter
linters73822633linter_s
lintier73613803lin_tier
lippered13287953lippered
listener8158313listener
littered92511383littered
litterers9228193litterers
livener10278943li_vener
livered113111633li_vered
loiterer837083loiterer
longer75823203long__er
longeron945763longeron
longers84819543longer_s
lumberer12177583lumberer
lungee75119813lunge_e_
lungees84412143lunge_es
lunger75720423lung__er
lungers83817093lunger_s
malingered1442713malingered
malingerers1451753malingerers
mingier103815293ming_ier
mingler104213843ming_ler
miterer92511333mi_terer
mongered1238953mongered
panderer112210913panderer
pilferer1344923pilferer
pinger94324093ping__er
pingers104020743pinger_s
plunderer1243753plunderer
ponderer112410193ponderer
renderer9239743renderer
ringer74526063ring__er
ringers83922953ringer_s
silverer11216733silverer
simperer1237173simperer
sincere9310553sincere_
singer74227313sing__er
singers83824703singer_s
sintered92213903sintered
slanderer1046673slanderer
slenderer1044893slenderer
slinger83413833sling__er
slingers93712683slinger_s
sliverer11237633sli_verer
sneerer73512313_sneerer
sniggerer1142723sniggerer
sunderer9310523sunderer
tenderer9228733tenderer
tingler83613343ting_ler
tinglier956403tinglier
tinkered1387683tinkered
tinkerers1395423tinkerers
titterer8268523titterer
veneerer1145033veneerer
wagerer11328493_wagerer
wanderer122210123wanderer
winger104125443wing__er
wingers113921483winger_s
wingier113413283wing_ier
wingover1544303wingover
wintered122111573wintered
winterers12209723winterers
winterier1238333winterier
witherer14187953witherer
wonderer12249183wonderer
zingare1737143zingare_
zinger163816703zing__er
zingers173514853zinger_s
zingier17369493zing_ier

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.423422437.4
2DLD Change Limit1461621767.45319611.2
3Display Results1761760.0762315.8
 (SQL Overall)1786911767.95222471.2
 
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.