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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

187 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
sinters7402407(None) 
hinters103719571hinters
inters64328041_inters
linters73822621linters
minters93822461minters
sifters103714781sifters
singers83824701singers
sinkers113618541sinkers
sinners74019021sinners
sinter63625921sinter_
sisters73721571sisters
sitters74221541sitters
stinters83312741stinters
tinters74221101tinters
winters103720471winters
banters94623112banters
binders103920742binders
biners85023632bin_ers
bingers104519992bingers
bisters93922602bisters
biters83925232bi_ters
bitters94920352bitters
bunters94717112bunters
canters94827722canters
centers94420592centers
cinders104617752cinders
citers85022972ci_ters
cointers103616402cointers
dieters83216422dieters
diners75525952din_ers
dingers94321382dingers
dinners83915442dinners
disinters1039702disinters
enters64425642_enters
fainters11349692fainters
filters103816542filters
finders113717872finders
fingers113418432fingers
fitters104517742fitters
gingers94118642gingers
ginners84314222ginners
hinders113718502hinders
hingers113420202hingers
hinter94021302hinter_
hitters104717582hitters
hunters103915722hunters
infers93615442_infers
inkers104018832_inkers
inners63919352_inners
inter55028492_inter_
intern64016542_intern
interns73116762_interns
jilters144211952jilters
jinkers183511812jinkers
jitters144314462jitters
jointers15289322jointers
kilters113813592kilters
kiters105218582ki_ters
lifters104313772lifters
liners65428852lin_ers
lingers84223302lingers
linkers114317712linkers
lintels73311162lintels
linter64625342linter_
listers74026522listers
liters65429872li_ters
litters73422562litters
milters93619082milters
mincers113714842mincers
minders103720112minders
miners84126632min_ers
minsters103813912minsters
minter84425102minter_
misinters1138162misinters
misters93927502misters
miters84328772mi_ters
niters64624202ni_ters
painters103013022painters
pincers113916502pincers
pinders103720472pinders
pingers104020742pingers
pinkers134118602pinkers
pinners93518602pinners
pointers103013722pointers
printers103214902printers
punters93617032punters
qintars16268572qintars
ranters73323642ranters
reinters82614772reinters
renters74224812renters
ringers83922952ringers
rinsers73815742rinsers
rioters73615502rioters
ritters74020612ritters
salters73622252salters
sanders84025942sanders
sangers84421942sangers
santera7311302santera
santeras8311052santeras
santero7311132santero
santeros8311192santeros
santirs7312962santirs
santurs7310762santurs
saunters82911742saunters
scoters93313792scoters
seaters74028932seaters
seiners74219272sein_ers
senders83022352senders
setters73822062setters
shifters14319852shifters
shiners104015942shin_ers
shunters113210732shunters
sidlers83414222sidlers
sifter94516232sifter_
sighers113712172sighers
sighters122510592sighters
signers84714432signers
sillers73822092sillers
silvers104714032silvers
simmers113314612simmers
simpers113014112simpers
sincere9310552sincere
sines55954822sin_e_s
sinews94210622sin_ews
singer74227312singer_
singes74326852singe_s
sinker103620902sinker_
sinless73014212sinless
sinner64320602sinner_
sintered92213902sintered
sippers113117742sippers
sister64421582sister_
sitars65417592si_tars
sites56045432si_te_s
sitter63323382sitter_
sivers95324152si_vers
sixtes133612402sixte_s
sizers155215812si_zers
skaters113512942skaters
skinkers11298172skinkers
skinners12347282skinners
skirters12337232skirters
skitters12349542skitters
slaters73123722slaters
slingers93712682slingers
slitters84014132slitters
smiters93414362smiters
sneers64016172s_neers
snifters11318602snifters
snipers93311762snipers
sonders83820712sonders
sorters74221112sorters
souters74422582souters
spinners103810862spinners
spinsters1136602spinsters
spitters104113382spitters
splinters11277922splinters
sprinters11329362sprinters
squinters1835512squinters
staters73922322staters
stingers94012732stingers
stinkers123111122stinkers
stinter73614512stinter_
suiters73618872suiters
sunders84120052sunders
swifters14277482swifters
swingers123710422swingers
tenters73921102tenters
tilters73315932tilters
tinders84219172tinders
tinkers113517142tinkers
tinners73717312tinners
tinter63923642tinter_
titers64526402ti_ters
titters74219612titters
uniters73814172uniters
venters103717722venters
vintners1134572vintners
wanters104420092wanters
wincers123415362wincers
winders113721262winders
wingers113921482wingers
winkers143517112winkers
winners104316912winners
winter94222802winter_
wintery13399752wintery
zingers173514852zingers

Search took 6 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 Filter1786911076710.1431249587.4
2DLD Change Limit1076711875.56319354.8
3Display Results1871870.1401335.7
 (SQL Overall)1786911875.84630566.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.