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

156 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
carports123894(None) 
carport11316031carport_
airports1046462airports
campouts1436822campouts
carboras12311582carboras
carpers114521252carper_s
carpets113915332carp_ets
carpools1237882carpools
carrots9714622carro_ts
cavorts1237932ca_vorts
comports143411982comports
purports1265782purports
rapports1245962rapports
aborts84916183_a_borts
acarpous1245313acarpo_us
airport9511383airport_
airposts1045923airposts
aport75432173_a_port_
arbores94016033_arbores
arbors84717883_arbor_s
ardors74416873_ardor_s
argots74116033_argo_ts
armors85017813_armor_s
arpents93613083_arpents
assorts73310153_assorts
cahoots1238473ca_hoots
campers134220293camper_s
camphors1737053camphor_s
campongs15356123campongs
camporee1449343camporee
camporees1546103camporees
campos125217953campo__s
campout13412853campout_
candors104216763candor_s
cantors94620753cantor_s
capers105428143ca_per_s
caplets114914523ca_plets
capons104119503ca_po_ns
caporal11410943ca_poral
caporals1238923ca_porals
capos94826073ca_po__s
capote10315733ca_po_te
capotes11314643ca_potes
cappers134419403capper_s
capris10415083ca_p_ris
caprocks1835943caprocks
captors113914983captor_s
carats85929023car__ats
carbarns1238563carbarns
carbons115418943carbo_ns
carbora11310703carbor_a
carbos105122263carbo__s
carboys144711783carbo_ys
carburets1345203carburets
carders104820353carder_s
cardons104519943cardo_ns
cardoons113411943cardoons
careers95218783career_s
carers85133963car_er_s
carets85330773car__ets
carfares13310323carfares
cargoes104415223cargo_es
cargos94619183cargo__s
carhops14329703carho_ps
cariocas1239663cariocas
carioles10817073carioles
carious93320283cario_us
carloads1138393carloads
carnets93918403car_nets
carobs104818103car_o_bs
carols85124983car_o_ls
carolus94612603car_olus
caroms105619573car_o_ms
carpals113414633carp_als
carpels115315463carp_els
carper104923633carper__
carpet104530093carp_et_
carpings133812393carpings
carpool1139223carpo_ol
carps96932253carp___s
carpus105514303carp__us
carroms11512403carro_ms
carrot8423123carro_t_
carroty1248943carro_ty
carrs75730853car__r_s
carryouts1443453carryouts
carters95327253carter_s
cartons94122473carto_ns
cartoons104012803cartoons
carts78946293ca___rts
carvers124817543carver_s
castors94919443castor_s
catboats1247873catboats
cavort11316173ca_vort_
chariots1339393chario_ts
charpoys1834533charpo_ys
cohorts123411103c_ohorts
comforts15347323comforts
comparts144210833comparts
comport133616843comport_
composts144210913composts
consorts101512343consorts
contorts101112643contorts
copouts11311083c_opouts
corpora1139353corpor_a
corporal1248513corporal
corporals1347273corporals
corporate13410903corporate
corporates14410733corporates
crapolas1247403crapolas
crofts114910593c_r_ofts
crores86121163c_r_ores
cruors838643c_ruor_s
cursors93910023cursor_s
deports105012883_deports
disports111111113disports
earworms1346783earworms
exports1647983_exports
fanworts1446103fanworts
gosports1185913gosports
harbors12412413harbor_s
harlots103413293harlo_ts
harpers124916203harper_s
harpists1338103harpists
harpoons1337483harpoons
imports11309623_imports
jetports1743533jetports
lakeports1543383lakeports
madworts1456173madworts
marmots11311513marmo_ts
marplots1245633marplots
outports1048273outports
parlors9312913parlor_s
parrots9312743parro_ts
passports1344243passports
ports75934593___ports
purport1159393purport_
ragworts12125803ragworts
ramparts1245583ramparts
rapport11311223rapport_
reports94916213_reports
sapors84118813sa_por_s
sartors7314973sartor_s
scarpers124712513scarper_s
seaports1038463seaports
sports84619183__sports
starworts12105273starworts
supports1246513supports
taproots1047253taproots
tarots66422993tar_o_ts
tarpons92612213tarpo_ns
torpors939383torpor_s
vapors113812693va_por_s
warlords1245303warlords
warpers123413583warper_s
warworks1877063warworks

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621567.81318707.5
3Display Results1561560.0632476.2
 (SQL Overall)1786911568.29621539.4
 
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.