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

110 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
lingerers1012692(None) 
fingerers13136301fingerers
lingerer9118301lingerer_
fingerer12127222fingerer_
hinderers1337352hinderers
lingered10129642lingere_d
lingeries10511812lingeries
lingers84223302ling__ers
litterers9228192litterers
malingerers1451752malingerers
tinkerers1395422tinkerers
winterers12209722winterers
banterers112410013banterers
bickerers17115603bickerers
bingers104519993bing__ers
blunderers1343943blunderers
cipherers1644893cipherers
clingers113810663cling__ers
congeners122511133congeners
dingers94321383ding__ers
ditherers13196683ditherers
enterers82214153_enterers
fidgeters1443623fidgeters
figurers12254873fi_gurers
filterers12206973filterers
fingered13128333fingere_d
fingers113418433fing__ers
flingers123410193fling__ers
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
langrels9106173lang_rels
lannerets9225483lannerets
latherers12158853latherers
launderers1183873launderers
letterers9228113letterers
libelers10238623li_belers
ligers75022043li_g__ers
lighters123111393li_ghters
ligures8269893li_gure_s
limberer12187053limberer_
lineless82711943lin_eless
linerless936333lin_erless
liners65428853lin___ers
lingberry1542313lingber_ry
linger75226003ling__er_
lingerie959203linger_ie
lingering11310513lingering
lingier84113383ling_ier_
lingoes84014693ling_oe_s
linkers114317713lin__kers
linseeds944733linse_eds
linters73822633lin__ters
listeners9147333listeners
litterer82810173litterer_
liveners11217933li_veners
loiterers936263loiterers
longerons1045893longerons
longers84819543long__ers
lumberers13196013lumberers
lungees84412143lunge_e_s
lungers83817103lung__ers
malingerer1342173malingerer_
minglers113011293ming_lers
miterers10219683mi_terers
panderers12229153panderers
pilferers1444583pilferers
pingers104020743ping__ers
plunderers1343343plunderers
ponderers12248453ponderers
renderers10208093renderers
ringers83922953ring__ers
silverers12215753silverers
simperers1335933simperers
sincerer1037203sincerer_
singers83824703sing__ers
slanderers1145143slanderers
slingers93712683sling__ers
sliverers12196363sli_verers
sneerers8309803_sneerers
sniggerers1242193sniggerers
sunderers1039073sunderers
tenderers10227803tenderers
tinglers93710593ting_lers
tinkerer1286803tinkerer_
titterers9236993titterers
veneerers1244523veneerers
wagerers12247613_wagerers
wanderers13228483wanderers
wingers113921483wing__ers
wingovers1643553wingovers
winterer112110443winterer_
witherers15146843witherers
wonderers13217933wonderers
zingers173514853zing__ers

Search took 9 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 Limit1486411107.78019105.5
3Display Results1101100.0462391.3
 (SQL Overall)1786911108.24921662.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.