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

173 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
caravan123922(None) 
caravans1338611caravans
carabao1139672carabao
carabin11313212carabin
caracal11312512caracal
caragana1146272caragana
carapax1835792carapax
caravaned1544982caravaned
caravaner1444732caravaner
caravel1238202caravel
caraway1538132caraway
carman103920742car_man
carven114716662car_ven
casava1157872casava_
casavas1237812casavas
cravat11314442c_ravat
craven114113932c_raven
paravane1348092paravane
acaridan1165233acaridan
acrasin9311223acrasin
arval86017013_ar_val
ataman81013063_ataman
barchan1469133barchan
barman103519703bar_man
brava106414793_brava_
bravas114913323_bravas
cabala103516913cabala_
cabalas113516003cabalas
cabana103913563cabana_
cabanas112413033cabanas
cabman123812503ca_bman
cadaver1335783cadaver
caftan111710123ca_ftan
caiman103615663ca_iman
calamar1149293calamar
callan83619603ca_llan
cameraman1542913cameraman
canakin131810833canakin
cancan10314103ca_ncan
canvas113813333ca_nvas
capelan1139003capelan
capstan1137903capstan
captan101613343ca_ptan
carabaos1238073carabaos
carabid12311333carabid
carabine12412383carabine
carabins12312353carabins
caracals12310743caracals
caracara1247243caracara
carack142113173cara_ck
caracks152211563caracks
caracol11310423caracol
caracul1138823caracul
carafe115416163cara_fe
carafes125015703carafes
caraganas1245783caraganas
carageen1155633carageen
caramba1336893caramba
caramel11310253caramel
carapace1446083carapace
carat75048793car__at
carate84734003cara_te
carates95630613carates
carats85929023cara_ts
caravaners1544133caravaners
caravaning1644423caravaning
caravanned1652673caravanned
caravanner1552633caravanner
caravels1337433caravels
caraways1636943caraways
carbarn1139453carbarn
carbon104919043car_bon
cardamon1345553cardamon
cardia9916373cardia_
cardiac1278813cardiac
cardiae10713703cardiae
cardias10715113cardias
cardigan1245613cardigan
cardon94120853car_don
cardoon104813813cardoon
careen84119493car_een
carina84325323carina_
carinae94318583carinae
carinal94318233carinal
carinas93622403carinas
caritas93316953caritas
carlin84421823car_lin
carload1039783carload
carmen104019343car_men
carn66245433car___n
carnal83919203car_nal
carnival1345613carnival
carotin92216733carotin
carpal103716253car_pal
carrion9312673carrion
carryon1237033carryon
carton84522663car_ton
cartoon94114463cartoon
carve106227753car_v_e
carved124320853car_ved
carvel114817573car_vel
carver114420143car_ver
carves115128453car_ves
carving133916773car_ving
casaba1079263casaba_
casabas1139983casabas
cassava1255003cassava_
cassavas1344803cassavas
cateran9313773cateran
caveman1437073caveman
cayman133613213ca_yman
ceramal1138843ceramal
ceratin93020163ceratin
charabanc1842923charabanc
characin1547993characin
charlatan1443543charlatan
chazan20269133c_hazan
corban10314693cor_ban
cordovan1444293cordovan
craal74117753c_ra_al
craton84517193c_raton
cravats1237393c_ravats
crave105626313c_rav_e
craved125417773c_raved
cravens124010113c_ravens
craver114618463c_raver
craves115825393c_raves
craving134015733c_raving
crayon114110003c_rayon
curacao1146293curacao
curara83712203curara_
curaras93911953curaras
curran8312023cur_ran
czarevna2241253czarevna
darshan1167063darshan
faraday1445633faraday
faraway1645413faraway
galavant1246353galavant
graven104513523_graven
halavah16447023halavah
hardpan1336443hardpan
harijan1735783harijan
larva8312483lar_va_
larvae938843lar_vae
larval948503lar_val
larvas9310233lar_vas
maraca10314153maraca_
maracas11313773maracas
martian93514683martian
oarsman937733oarsman
papayan1445303papayan
paragon10311023paragon
parasang1147333parasang
paravanes1448293paravanes
parazoan1946553parazoan
parian83223963par_ian
partan83820563par_tan
pavan106518473__pavan
ratan53722663__ratan
raven84723443__raven
ravin85624653__ravin
sagaman10117563sagaman
saraband1146193saraband
saran53730303sar__an
tarama8412733tarama_
taramas9612703taramas
tarlatan845063tarlatan
tarpan82814293tar_pan
tartan64217513tar_tan
tarzan152910753tar_zan
trapan82412973_trapan
yardman1335913yardman
yatagan1144133yatagan

Search took 8 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.390458182.1
2DLD Change Limit1340271737.05019010.9
3Display Results1731730.0602883.3
 (SQL Overall)1786911737.50023825.5
 
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.