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

101 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
counter9422015(None) 
chunter123911481chunter
cointer93616721cointer
coulter94115601coulter
counted103815801counted
counters103320191counters
courter94516481courter
couter84930221cou_ter
mounter93713171mounter
blunter94512042blunter
bouncer113811332bouncer
bounder104215542bounder
bunter85020382_bunter
canter85230112c_anter
center84421412c_enter
chanter123919732chanter
chaunter1366392chaunter
chunters133910902chunters
clouter93511692clou_ter
clunker13419462clunker
cluster94013332cluster
clutter94211662clutter
coaster94219042coaster
coater84329572co_ater
coiner84323782coin_er
coinfer12419392coinfer
cointers103616422cointers
colter84625092co_lter
confer114018682co_nfer
conger95024272co_nger
conker124721552co_nker
conner84423962co_nner
conte76633202co_nte_
contes84432912co_ntes
cooter85128612co_oter
copter109822012co_pter
corner84625622corn_er
cornier93017092cornier
coster84331292co_ster
cotter84926672co_tter
coucher144515852coucher
cougher133711732cougher
coulters103614312coulters
counsel948542counsel
count74932052count__
countered12313002countered
countess103710052countess
counties10316282counties
country12388042country
counts84618272count_s
county114313322count_y
coupler114713012coupler
courier93617892courier
courser94114802courser
courted103514922courted
courters103015372courters
courtier1059332courtier
couters93827302cou_ters
couther123914632couther
coveter122912062coveter
cunner83915002c_unner
curter85320082c_urter
cuter74728232c_u_ter
cutter84521002c_utter
daunter83811752daunter
doubter10298352doubter
encounter1145182encounter
founder114312582founder
gaunter82910712gaunter
grunter83110782grunter
haunter103111152haunter
hounder113412242hounder
hunter94817772_hunter
jointer14379712jointer
jouster143311042jouster
lounger84610212lounger
moulter93812422moulter
mounted103611532mounted
mounters103712502mounters
ouster64223732_ouster
outer55633302_ou_ter
pointer93814932pointer
poulter93712012poulter
pouncer113511242pouncer
pounder103314012pounder
pouter83923982pou_ter
punter84320032_punter
recounter1137942recounter
rounder83514612rounder
rouster73517082rouster
router65025842rou_ter
saunter72913452saunter
scouter93313322scou_ter
shunter103611732shunter
sounder83315392sounder
souter64225922sou_ter
taunter73111452taunter
touter63821032tou_ter
vaunter10309602vaunter
younger11387162younger
younker14316452younker

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 Filter1786911076710.780229091.0
2DLD Change Limit1076711017.53314293.2
3Display Results1011010.0801262.5
 (SQL Overall)1786911018.39321290.5
 
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.