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

212 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
carload103978(None) 
carloads1138391carloads
cartload1145031cartload
armload1044292_armload
caroled103717692caroled
cartloads1244522cartloads
caseload1145622caseload
payload1336402payload
vanload1144702vanload
warlord1136292warlord
abroad9310943_abroad
acaroid103512313acar_oid
afloat9315153_afloat
allod64418383_allo_d
aloud65018073_a_loud
armloads1144233_armloads
aroid65428343_ar_oid
backload1746833backload
ballad94315323ba_llad
barlow112911433barlo_w
barlows12259983barlows
boatload1143403boatload
broad84817693_br_oad
busload1044683busload
byroad1236623byr_oad
cabled114819873cabl_ed
cactoid12311033cactoid
cajoled17428283cajoled
calcar10312753ca_lcar
calked134617403ca_lked
calla74827073ca_lla_
callan83619603ca_llan
callas84526753ca_llas
callboard1445663callboard
called94126733ca_lled
callose9313663callose
callous93516603callous
callow114714663callo_w
calmed114816383ca_lmed
calo64936443ca_lo__
calory11312843ca_lory
calos74431903ca_lo_s
calpac123211063ca_lpac
calved125215453ca_lved
cameoed1238383cameoed
canoed94618963ca_noed
canola8313623canola_
canolas9313993canolas
carabao1139673carabao
carabid12311333carabid
caracal11312513caracal
carapax1835793carapax
carat75048793car__at
caravan1239233caravan
caraway1538133caraway
carbo94923843carbo__
carbon104919043carbo_n
carbonade1446543carbonade
carbonado1444383carbonado
carbons115418943carbons
carbora11310703carbora
carboras12311583carboras
carbos105122263carbo_s
carboy134914183carbo_y
carboyed1637183carboyed
carboys144711783carboys
card710245873car___d
cardboard1545863cardboard
carded105424903car_ded
cardia9916383cardia_
cardiac1278823cardiac
cardiae10713713cardiae
cardias10715123cardias
cardioid1247453cardioid
cardon94120853cardo_n
cardons104519943cardons
cardoon104813813cardoon
cared86050093car__ed
cargo85322073cargo__
cargoes104415223cargoes
cargos94619183cargo_s
carhop133610763carho_p
carhops14329703carhops
caried94528693car_ied
carina84325333carina_
carinae94318593carinae
carinal94318243carinal
carinas93622413carinas
carioca1139683carioca
cariocas1239663cariocas
cariole9818343cariole
carious93320283carious
caritas93316963caritas
carked134024823car_ked
carl65144783carl___
carle74535703carl__e
carles85435083carl_es
carless95118493carless
carlin84421823carl_in
carline93923623carline
carling103727063carling
carlins93921923carlins
carlish12312773carlish
carls77037423carl__s
carman103920743car_man
carnal83919213car_nal
caroach1488863car_oach
carob95325223car_o_b
carobs104818103car_obs
caroch13911763car_och
carol75128613car_o_l
caroler93816753caroler
caroli85918233car_oli
carolled1138833carolled
carols85124983car_ols
carolus94612603carolus
carom95025563car_o_m
caromed123713623caromed
caroms105619573car_oms
carotid102014833carotid
carpal103716253car_pal
carped115923763car_ped
carpool1139223carpool
carport11316033carport
carried103717153carried
carroch1437093carroch
carrom10513403carro_m
carromed1338573carromed
carroms11512403carroms
carronade1246093carronade
carrot8423123carro_t
carrots9714623carrots
carroty1248943carroty
carted98631443car_ted
carton84522663carto_n
cartoned111312833cartoned
cartons94122473cartons
cartoon94114463cartoon
cartop104213563carto_p
carved124320853car_ved
caseloads1244283caseloads
catboat11412243catboat
cathead1338753cathead
caudad10157673ca_udad
cauld85318443caul__d
caulked14486673caulked
charcoal15165743charcoal
charlady1743403charl_ady
charlock1944393charlock
cheloid13310833cheloid
chiliad1337563chiliad
cirsoid1038123cirsoid
clad76225823c__l_ad
cloak115214013c__loak
clod76124613c__lo_d
cloud86716423c__loud
colead94114643c_olead
colloid10312883colloid
cormoid12310403cormoid
crawdad1443113crawdad
croak115216633c_r_oak
crowd115815623c_r_owd
curled95021653curl_ed
cycloid1539283cycloid
earlap837183earl_ap
earlobe946553earlobe
earlock1336923earlock
fairlead1243513fairlead
farad95720673far__ad
garboard1247243garboard
garland948703garland
halloa94918123halloa_
halloaed121510153halloaed
halloas104318463halloas
halloed113314913halloed
haloed104717603ha_loed
haloid104317763ha_loid
haploid1339833haploid
harlot94422803harlo_t
harlots103413293harlots
inroad737933inr_oad
jarhead1835173jarhead
larboard1157663larboard
load56730603___load
marled95523163marl_ed
oarlock1336123oarlock
offload1443203offload
onload7268633_onload
overload12119283overload
parlay113713993parl_ay
parled94626293parl_ed
parlor8312673parlo_r
parlors9312913parlors
parlour937263parlour
parlous9414293parlous
paroled104217633paroled
payloads1445293payloads
preload1049813preload
railroad943803railroad
reload7413893_reload
road56332113__r_oad
salad65321833sa_l_ad
sarcoid10310453sarcoid
sarod65325873sar_o_d
tabloid1048263tabloid
unload73010803_unload
upload9257783_upload
vanloads1264163vanloads
warhead1436603warhead
warlock1636293warlock
warlords1245303warlords
workload1643023workload

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 Filter1786911340270.436409841.7
2DLD Change Limit1340272128.25316239.8
3Display Results2122120.0762789.5
 (SQL Overall)1786912128.76520386.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.