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 “fingerers” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
fingerers1313630(None) 
fingerer12127221fingerer_
lingerers10126921lingerers
fidgeters1443622fidgeters
figurers12254872fi_gurers
filterers12206972filterers
fingered13128332fingere_d
fingers113418432fing__ers
hinderers1337352hinderers
lingerer9118302lingerer_
tinkerers1395422tinkerers
winterers12209722winterers
banterers112410003banterers
bickerers17115593bickerers
bingers104519993bing__ers
cipherers1644893cipherers
congeners122511133congeners
dingers94321383ding__ers
ditherers13196683ditherers
enterers82214153_enterers
falterers12238033falterers
fetterers12267043fetterers
fidgeter1343783fidgeter_
figeaters1345753fi_geaters
fighters15269403fi_ghters
figurer11215863fi_gurer_
figures11239113fi_gure_s
filterer11258143filterer_
finaglers13173893finaglers
finders113717873fin__ders
fineness11310643fin_eness
fineries112416743fin_eries
finger104920333fing__er_
fingering1439193fingering
fingerings1545073fingerings
fingerpost1652813fingerpost
fingertip1572733fingertip
fingertips1692773fingertips
finishers1545353finishers
firers94922683fi___rers
flingers123410193fling__ers
flowerers1544503flowerers
fosterers12238023fosterers
fritterers13203393fritterers
gingeleys14272893gingeleys
gingered11127743gingere_d
gingers94118643ging__ers
hankerers16226713hankerers
hinderer1238273hinderer_
hingers113420213hing__ers
ignorers9215243_ignorers
indexers16326373_indexers
inferrers12226583_inferrers
ingress838653_ing_ress
inheres10315173_inhere_s
injurers15286123_injurers
inserters92210283_inserters
insurers83710133_insurers
integers937783_integers
inverters12239753_inverters
jinglers16408763jing_lers
kipperers17233823kipperers
lingered10129643lingere_d
lingeries10511813lingeries
lingers84223303ling__ers
litterers9228193litterers
malingerers1451753malingerers
minglers113011293ming_lers
miterers10219683mi_terers
panderers12229153panderers
pilferers1444583pilferers
pingers104020743ping__ers
ponderers12248453ponderers
renderers10208093renderers
ringers83922953ring__ers
silverers12215753silverers
simperers1335933simperers
sincerer1037203sincerer_
singers83824703sing__ers
sneerers8309803_sneerers
sniggerers1242193sniggerers
sunderers1039073sunderers
tenderers10227803tenderers
tinglers93710593ting_lers
tinkerer1286803tinkerer_
titterers9236993titterers
veneerers1244523veneerers
wagerers12247613_wagerers
wanderers13228483wanderers
wingers113921483wing__ers
wingovers1643553wingovers
winterer112110443winterer_
witherers15146843witherers
wonderers13217933wonderers
zingers173514853zing__ers

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 Filter1786911486410.423422437.4
2DLD Change Limit148641956.53022762.8
3Display Results95950.0462065.2
 (SQL Overall)178691956.99925530.9
 
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.