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

148 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
integers93778(None) 
integer837991integer_
enterers82214152enterers
indexers16326372indexers
intenders10219372intenders
inters64328052int__ers
intoners889932intoners
vintagers13123902vintagers
winterers12209722winterers
allegers9378233allegers
alterers82512493alterers
angers75222543an__gers
anteaters939343anteaters
antevert1148993antevert
anteverts1244723anteverts
anthers103715203ant_hers
antigens9310603antigens
antlers74014743ant_lers
banterers112410003banterers
bingers104519993bin__gers
caterers102814403caterers
detergers11147183detergers
dingers94321383din__gers
egers65120373___egers
enfevers1444513enfevers
engagers10246553engagers
enterer72015633enterer_
enters64425643ent__ers
enticers10139093enticers
filterers12206973filterers
fingerers13136303fingerers
fingers113418433fin__gers
gingers94118643gin__gers
hinderers1337353hinderers
hingers113420213hin__gers
hinters103719583hint__ers
imagers10107763i_magers
impeders13346593impeders
incages103013883incage_s
incenters112510303incenters
inchers123912523in_chers
inciters103210673inciters
incomers1268593incomers
indenes82916253indene_s
indenters102710033indenters
indexer15287253indexer_
indexes15339453indexe_s
indigens10288733indigens
inditers93311053inditers
inducers11326953inducers
indulgers1143803indulgers
infecters14257583infecters
inferrers12226583inferrers
infers93615443in__fers
infesters12237713infesters
infusers11286143infusers
inhalers1166643inhalers
inheres10315173inhere_s
inhumers1364823inhumers
injurers15286123injurers
inkers104018833in__kers
inlayers1135643inlayers
inliers73110743in_liers
innages82911303innage_s
inners63919353in__ners
inserters92210283inserters
insetters9187133insetters
insiders947763insiders
insurers83710133insurers
intakes11310943intake_s
integral946783integral
integrals1046463integrals
intendeds11265743intendeds
intender93310443intender_
intends8239963inte_nds
intenser8199443intenser_
intents72115703inte_nts
inter55028493int__er_
interbeds12238903interbeds
interest8319183interest
interests9312553interests
interfere12410813interfere
interferes1349983interferes
interims101013073interims
interiors9513563interiors
intern64016543int__ern
internees93014843internees
internes82721233internes
interns73116773inte_rns
interred92615263interred
interrex15249823interrex
interterm1148813interterm
intines7921113intine_s
intoner7811673intoner_
intones7816543intone_s
intriguers1143333intriguers
intruders1044743intruders
invaders12105303invaders
inveighers1742023inveighers
inveiglers1442043inveiglers
inventers12269533inventers
inverters12239753inverters
inviters11359643inviters
invokers1534673invokers
jaegers15307103_jaegers
kneelers12226213kneelers
legers74518313__legers
lingerers10126923lingerers
lingers84223303lin__gers
linters73822633lint__ers
listeners9147323listeners
litterers9228193litterers
mintages111110513mintage_s
minters93822473mint__ers
miterers10219683miterers
naggers93812653_naggers
needers84111903_needers
netters73618583_netters
niggers93111323_niggers
niters64624213nit__ers
nudgers9479373_nudgers
onagers838103on_agers
pingers104020743pin__gers
renegers9248793renegers
ringers83922953rin__gers
singers83824703sin__gers
sinters74024083sint__ers
sneerers8309803sneerers
sneers64016173sn_e_ers
sneezers17246143sneezers
sniggers10317093sniggers
stagers84116673_stagers
steers63820983_ste_ers
tigers75616513__tigers
tinkerers1395423tinkerers
tinters74221113tint__ers
titterers9236993titterers
untethers1244153untethers
utterers8218653utterers
vinegars1245063vin_egars
vintager12104823vintager_
vintages12118273vintage_s
vintners1134573vint_ners
waterers112312783waterers
wingers113921483win__gers
winterer112110443winterer_
winters103720483wint__ers
zingers173514853zin__gers

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 Filter1786911461620.860207780.2
2DLD Change Limit1461621487.48619524.7
3Display Results1481480.0632349.2
 (SQL Overall)1786911488.40921250.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.