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

144 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
fingerer1212722(None) 
fingered13128331fingered
fingerers13136301fingerers
lingerer9118301lingerer
fidgeter1343782fidgeter
figurer11215862fi_gurer
filterer11258142filterer
finger104920332fing__er
fingers113418432finger_s
gingered11127742gingered
hinderer1238272hinderer
lingered10129642lingered
lingerers10126922lingerers
sincerer1037202sincerer
tinkerer1286802tinkerer
winterer112110442winterer
angered93013473_angered
banterer102811773banterer
befingered1742843befingered
bickerer16106773bickerer
binger94923453bing__er
bingers104519993binger_s
bitterer10309773bitterer
cindered1239793cindered
cipherer1545573cipherer
congener112412203congener
dangered11248513dangered
dinger85323673ding__er
dingers94321383dinger_s
dingier93513673ding_ier
ditherer12187763ditherer
eagerer8248823_eagerer
enterer72015633_enterer
falterer11239863falterer
fendered13258673fendered
fetterer11207813fetterer
fibered1337643fi_bered
fidgeted1443893fidgeted
fidgeters1443623fidgeters
fiercer12356953fi__ercer
fierier103511193fi__erier
figeater1236953fi_geater
fighter143010773fi_ghter
figure10258833fi_gure_
figured12196473fi_gured
figurers12254873fi_gurers
figures11239113fi_gures
filtered12259043filtered
filterers12206973filterers
finagler12194953finagler
finder104020233fin__der
finders113717873finder_s
finer85431563fin___er
fineries112416743fin_eries
finery124512893fin_er_y
fingering1439193fingering
fingertip1572733fingertip
finisher1436303finisher
finnier10319953fin_nier
firer811229253fi___rer
flinger113710513fling__er
flingers123410193flinger_s
flowerer1435453flowerer
fosterer11239523fosterer
fringier1236553fring_ier
fritterer12234403fritterer
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
limberer12187053limberer
linger75226003ling__er
lingerie959203lingerie
lingeries10511813lingeries
lingers84223303linger_s
lingier84113383ling_ier
litterer82810173litterer
malingerer1342173malingerer
mingier103815293ming_ier
mingler104213843ming_ler
miterer92511333mi_terer
mongered1238953mongered
panderer112210913panderer
pilferer1344923pilferer
pinger94324093ping__er
pingers104020743pinger_s
ponderer112410193ponderer
renderer9239743renderer
ringer74526063ring__er
ringers83922953ringer_s
silverer11216733silverer
simperer1237173simperer
sincere9310553sincere_
singer74227313sing__er
singers83824703singer_s
sintered92213903sintered
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.420425454.8
2DLD Change Limit1461621446.87621256.8
3Display Results1441440.0632285.7
 (SQL Overall)1786911447.35924282.0
 
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.