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

152 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
boxcars183477(None) 
boxcar1734751boxcar_
boars75229602bo__ars
bobcats1335992bobcats
boxers155013482box_ers
boyars115611982bo_yars
oxcart1539522_oxcart
oxcarts1634312_oxcarts
soucars938422soucars
sowcars1236012sowcars
baccara1347143baccara
baccaras1446913baccaras
barcas101016603barca_s
bars66564093b___ars
bazaars18275883bazaars
bazars174613113b_azars
bears75739043b__ears
becaps123811403b_ecaps
beggars11378223beggars
bezoars1836793bezoars
bicarb1238543b_icarb
bicarbs1336013b_icarbs
blears85116453b_lears
boar66134293bo__ar_
board85523003bo__ard
boards94616933bo__ards
boart78835933bo__art
boarts84716873bo__arts
boas66150833bo__a_s
boaters93419243boaters
boats75635153bo__ats
bobbers103614283bobbers
bobcat12411253bobca_t
bocces123912023bo_cces
boccias13307193boccias
boccies133311513boccies
boccis123911133bo_ccis
boches134618523bo_ches
bocks134526573bo_c_ks
bogans95714813bo_gans
bogart9617193bo_gart
bogarts1047743bo_garts
boheas114013213bohea_s
boilers93417063boilers
bolar75123473bo_lar_
bolas74733763bo_la_s
bolivars1344973bolivars
bollard103210503bollard
bollards11339153bollards
bolters94017803bolters
bombard1437333bombard
bombards1536493bombards
bombers134512593bombers
bonacis11310323bonacis
bonders104120663bonders
boners84825433bo_ners
bonkers134015303bonkers
boocoos1137753boocoos
boogers104514633boogers
bookers134016613bookers
boomers114115913boomers
boors74325013bo__ors
boozers183912443boozers
boppers133911923boppers
boraces113716853boraces
borals86721913bo_rals
boras75938303bo_ra_s
borders104317533borders
boreas85421733borea_s
borers85122683bo_rers
boscage1276533boscage
boscages1366643boscages
botas75328783bo_ta_s
botchers153511543botchers
botches143716023botches
bothers124317753bothers
boucles113113003boucles
bouncers12309353bouncers
bowers115523703bo_wers
bowlers123715783bowlers
bowyers15438733bowyers
boxball18155323boxball
boxballs19144233boxballs
boxboard2044613boxboard
boxboards2144263boxboards
boxer145016523box_er_
boxes145625073box__es
boxfuls19113603boxfuls
boxhaul1943013boxhaul
boxhauls2042073boxhauls
boxier154311743boxier_
boxings17429163boxings
boyar106013763bo_yar_
boyard125411283bo_yard
boyards13399323bo_yards
boylas113011723boyla_s
bracers114616703bracers
briars84814823b_riars
bursars94510893bursars
busbars1138153busbars
calcars11312653calcars
cars67364763___cars
cocas95926573co_ca_s
collars93816573collars
concurs11311473concurs
costars94218013costars
cottars94412243cottars
cougars1038443cougars
dogcart1148043dogcart
dogcarts1243883dogcarts
dogears937513dogears
dollars83311023dollars
escars83913133_escars
exocarp1843853exocarp
exocarps1953473exocarps
forcers124215713forcers
hoars85925553ho__ars
jowars16369653jo_wars
lascars979013lascars
locals83714503lo_cals
mobcaps1543463mobcaps
molars85517323mo_lars
mortars93411523mortars
moxas145014403mox_a_s
nonwars10109003nonwars
oars46846033_o__ars
ocas66729633_o_ca_s
occurs10136553_occurs
orcas75918623_orca_s
ottars64112223_ottars
oxters134813273_oxters
polars84419353po_lars
poplars113910333poplars
roars55622243ro__ars
scars75433533__scars
soars54732513so__ars
socas74026183so_ca_s
soccers1138393soccers
sofars94712783so_fars
sonars64818973so_nars
soucar839323soucar_
sowars94318013so_wars
sowcar1135863sowcar_
toecaps1135553toecaps
tolars64817943to_lars
tomcats11127773tomcats
toucans937583toucans
trocars959043trocars
vicars11712263_vicars
vocabs13336313vo_cabs
vocals113811583vo_cals
voicers12348993voicers

Search took 7 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 Limit1340271526.25021444.3
3Display Results1521520.0463304.3
 (SQL Overall)1786911526.71926594.9
 
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.