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

192 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
integer83799(None) 
integers937781integers
enterer72015632enterer
indexer15287252indexer
intender93310442intender
intenser8199442intenser
inter55028492int__er
intoner7811672intoner
vintager12104822vintager
winterer112110442winterer
alleger8319633alleger
alterer72713993alterer
anger66225873an__ger
anteater8311603anteater
anteed75616113ante_ed
antevert1148993antevert
anther93715063ant_her
antigen8311123antigen
antler64615553ant_ler
antsier7410773antsier
banterer102811773banterer
binger94923453bin__ger
bitterer10309773bitterer
caterer92815943caterer
deterger10147593deterger
dinger85323673din__ger
eger55923573___eger
enfever1344643enfever
engager9278603engager
enter54726383ent__er
entered82718883entered
enterers82214153enterers
enticer91510423enticer
filterer11258143filterer
finger104920333fin__ger
fingerer12127223fingerer
ginger84920033gin__ger
hinderer1238273hinderer
hinger104723333hin__ger
hinter94021303hint__er
imager9108123i_mager
impeder12438533impeder
inaner62213543in_aner
incage93513623incage_
incaged114010443incaged
incages103013883incages
incenter102212093incenter
incher114114033in_cher
inciter93113773inciter
incomer1169943incomer
indeed83913563inde_ed
indene73215373indene_
indenes82916253indenes
indenter92311443indenter
indexed16347363indexed
indexers16326373indexers
indexes15339453indexes
indigen9319333indigen
inditer83514233inditer
inducer10318763inducer
indulger1044153indulger
infecter13229153infecter
infer84215033in__fer
inferrer11217443inferrer
infester11239433infester
infuser10298323infuser
inhaler1068053inhaler
inhere9313713inhere_
inhered11313163inhered
inheres10315173inheres
inhumer1275383inhumer
injurer14318473injurer
inker94421093in__ker
inkier104013783in_kier
inlayer1036933inlayer
inlier63615363in_lier
innage73011573innage_
innages82911303innages
inner54920633in__ner
insaner7310443insaner
inserter82312133inserter
insetter8218593insetter
insider849733insider
insurer73312803insurer
intagli845023intagli
intake10510863intake_
intakes11310943intakes
integral946783integral
intend72310373inte_nd
intended102310413intended
intenders10219373intenders
intends8239963intends
intense72511903intense
intent63122773inte_nt
intents72115703intents
interage9314493interage_
interbed112413103interbed
interest8319183interest
interfere12410813interfere
interim9912873interim
interior8513093interior
intern64016543inte_rn
interne73218153interne
interned93016653interned
internee82718523internee
internes82721233internes
interns73116773interns
interred92615263interred
interrex15249823interrex
inters64328053inte_rs
intersex15209733intersex
interterm1148813interterm
interwar1148263interwar
intime81014273intime_
intine61021983intine_
intines7921113intines
intone61115433intone_
intoned8811993intoned
intoners889933intoners
intones7816543intones
intriguer1043873intriguer
intruder945213intruder
invader11146453invader
inveigher1642423inveigher
inveigler1342463inveigler
inventer112410843inventer
inverter112411073inverter
inviter104112313inviter
invoker1435363invoker
itemed936603i_temed
ither84617603i_t_her
jaeger14397193_jaeger
kneeler11277573kneeler
leger65721513__leger
linger75226003lin__ger
lingerer9118303lingerer
linter64625343lint__er
lintier73613803lint_ier
listener8158313listener
litterer82810173litterer
mintage101110123mintage_
mintages111110513mintages
minter84425103mint__er
mintier93615993mint_ier
miterer92511333miterer
nagger84016123_nagger
needer73614953_needer
nether94014163_nether
netter63722023_netter
never86218643_n_ever
newer85717463_n_ewer
nigger89713573_nigger
niter55028973nit__er
nittier73512243nittier
nudger85111643_nudger
oftener1035923oftener
onager739663on_ager
pinger94324093pin__ger
reneger8299493reneger
ringer74526063rin__ger
sincerer1037203sincerer
singer74227313sin__ger
sinter63625923sint__er
sintered92213903sintered
sneer54919953sn_e_er
sneerer73512313sneerer
sneezer16237963sneezer
snigger9328373snigger
snugger9318313snugger
stager74821343_stager
steer55423863_ste_er
tiger65718633__tiger
tinkerer1286803tinkerer
tinter63923643tint__er
titterer8268523titterer
uneager839753uneager
untether1145163untether
untruer737113untruer
utterer71910463utterer
vinegar1134613vin_egar
vintage11128143vintage_
vintagers13123903vintagers
vintages12118273vintages
vintner1034833vint_ner
waterer103314073waterer
winger104125443win__ger
winter94222803wint__er
wintered122111573wintered
winterers12209723winterers
winterier1238333winterier
wintrier1136873wintrier
zinger163816703zin__ger

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271927.00019146.7
3Display Results1921920.0762526.3
 (SQL Overall)1786911927.49923828.6
 
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.