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

159 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
carpool113922(None) 
carpools1237881carpools
camphol1645792camphol
caracol11310422caracol
cardoon104813812cardoon
carol75128612car__ol
carpal103716252carp_al
carpel105418472carp_el
carpooled1445072carpooled
carpooler1345312carpooler
carport11316032carport
cartoon94114462cartoon
harpoon1238312harpoon
vanpool1243762vanpool
acarpous1245313acarpous
argol65317263_ar_gol
babool103012153ba_bool
barroom1139373barroom
barstool1044233barstool
cahoot11416473ca_hoot
camphols1746243camphols
camphor1636133camphor
campion133011413campion
campo115219763camp_o_
campong14318123campong
campos125217953camp_os
campout13412853campout
campstool1571883campstool
capful1368173ca_pful
capitol11258283capitol
capo85829213ca_p_o_
capon95221873ca_p_on
capons104119503ca_pons
caporal11410943ca_poral
capos94826073ca_p_os
capote10315733ca_pote
capriole1276913capriole
caprock1736813caprock
captor104914603ca_ptor
caracal11312513caracal
caracole12310353caracole
caracols12310413caracols
caracul1138823caracul
caramel11310253caramel
caravel1238203caravel
carbinol1245773carbinol
carbo94923843car_bo_
carbon104919043car_bon
carbons115418943carbons
carbonyl1595383carbonyl
carbora11310703carbora
carbos105122263car_bos
carboxyl22103633carboxyl
carboy134914183car_boy
carboys144711783carboys
carcel105018673car_cel
cardio9915673cardio_
cardon94120853car_don
cardons104519933cardons
cardoons113411943cardoons
careful1249113careful
caretook1445173caretook
carful11610973car_ful
cargo85322073car_go_
cargoes104415223cargoes
cargos94619183car_gos
carhop133610763car_hop
carhops14329703carhops
caribou1156993caribou
carinal94318233carinal
carioca1139683carioca
cariole9818343cariole
carious93320283carious
carl65144783car___l
carload1039783carload
carnal83919203car_nal
carob95325223car__ob
carobs104818103car_obs
caroch13911763car_och
caroli85918233car_oli
carols85124983car_ols
carom95025563car__om
caroms105619573car_oms
carp85139813carp___
carpale113414353carpale
carpals113414623carpals
carped115923763carp_ed
carpels115315463carpels
carper104923633carp_er
carpers114521253carpers
carpet104530093carp_et
carpets113915333carpets
carpi94319393carp__i
carping123521083carping
carpology1775453carpology
carpoolers1444573carpoolers
carpooling1545023carpooling
carports1238943carports
carps96932253carp__s
carpus105514303carp_us
carrel84718633car_rel
carrell94610473carrell
carriole1089863carriole
carrion9312673carrion
carroch1437093carroch
carrom10513403car_rom
carroms11512403carroms
carrot8423123car_rot
carrots9714623carrots
carroty1248943carroty
carryon1237033carryon
cartel85022533car_tel
carton84522663car_ton
cartons94122473cartons
cartoons104012803cartoons
cartoony13377403cartoony
cartop104213563car_top
carvel114817573car_vel
cashoo11312253cashoo_
cashoos12310793cashoos
cesspool1242583cesspool
charcoal15165743charcoal
charpoy1735713charp_oy
charpoys1834533charpoys
cool66940493c___ool
corpora1139353corpora
corporal1248513corporal
crampoon1444543crampoon
crapola1136913crapola
creosol946053c_reosol
cresol8310213c_resol
crook115217573c_r_ook
croon75522783c_r_oon
drool65416103_dr_ool
garboil1036513garboil
harpoons1337483harpoons
jargoon1545193jargoon
karoo92519583kar_oo_
karoos102415803kar_oos
karroo10410013karroo_
karroos1139313karroos
lampoon11267193lampoon
lardoon83410373lardoon
maroon83118203mar_oon
marplot1149673marplot
parasol939553parasol
parboil1138323parboil
parol74826273par__ol
partook1337313partook
pool65835953___pool
respool937643respool
spool75219043__spool
taproom1147963taproom
taproot9412673taproot
tarpon82812803tarp_on
tarpons92612213tarpons
unspool945163unspool
vanpools1343193vanpools
varoom11411413var_oom

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.406440125.6
2DLD Change Limit1340271596.18621666.2
3Display Results1591590.0632523.8
 (SQL Overall)1786911596.65526850.6
 
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.