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

108 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
caraculs123803(None) 
caracals12310741caracals
caracols12310411caracols
caracul1138821caracul_
caracal11312512caracal_
caracks152211562carac_ks
caracol11310422caracol_
caracole12310352caracole
caracoles13310072caracoles
caramels1238802caramels
caravels1337432caravels
carcels114516062car_cels
carfuls1249132car_fuls
karakuls1142082karakuls
abacus10349763_abacu_s
arcus76918863_ar_cu_s
armfuls1275013_armfuls
cabals104020153caba__ls
cagefuls1484343cagefuls
cajaputs1942663cajaputs
calamus1139243calamu_s
calculi1146563ca_lculi
calculus1255333ca_lculus
calyculi1542153calyculi
calyculus1642243calyculus
camails11311753cama_ils
canals84421663cana__ls
cancels114113313ca_ncels
canfuls1248423ca_nfuls
capfuls1436523ca_pfuls
carabaos1238073carabaos
carabids1338193carabids
carabins12312353carabins
caracara1247243caracara
caracaras1346853caracaras
carack142113173carac__k
caracoled1445983caracoled
caracoler1346413caracoler
caracolers1445123caracolers
carafes125015703cara_fes
caramel11310253caramel_
carates95630613cara_tes
carats85929023cara__ts
caravans1338613caravans
caravel1238203caravel_
caraways1636943caraways
carbachols1942783carbachols
carbamyls1843033carbamyls
carbaryls1644013carbaryls
carcases12313083carcases
carcass11310513car_cass
carcel105018673car_cel_
cardamums1642603cardamums
careful1249113careful_
carful11610973car_ful_
carices114220953caric_es
carious93320283cariou_s
carjacks2345573carjac_ks
carls77037423car___ls
caroaches1637793caroaches
caroches15710693caroches
carols85124983car__ols
carolus94612603carolu_s
carpals113414623car_pals
carpels115315463car_pels
carpools1237883carpools
carpus105514303car_pu_s
carracks1637713carrac_ks
carrells10359263carrells
carrels95117303car_rels
cartels94618123car_tels
carvacrols1752013carvacrols
carvels124914593car_vels
catapult1245243catapult
catapults1342953catapults
catcalls1238323catcalls
caucus1039613ca_ucu_s
cauls75727773c__a_uls
ceramals1246513ceramals
cercus105013153cer_cu_s
characids1745263characids
characins1647583characins
circus104310593cir_cu_s
coracle112011723corac_le
coracles121811163coracles
corals85325143cora__ls
craals84113303c_ra_als
crackle153611253c_rackle
crackles164111273c_rackles
crackly18397703c_rackly
cracks144817003c_rac_ks
crackups1843123c_rackups
crawls114712083c_ra_wls
crocus104813173c_rocu_s
curacaos1244923curacaos
curacies12311763curacies
curacoas1246033curacoas
earaches13411303earaches
earfuls1036863ear_fuls
hamauls12387813hama_uls
jarfuls1754773jar_fuls
karakul1042553karakul_
maracas11313773marac_as
marauds1037553mara_uds
marcels113212373mar_cels
parasols1039263parasols
parcels113712663par_cels
uracils939373_uracils

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.1561145455.1
2DLD Change Limit1461621088.00018270.3
3Display Results1081080.0462347.8
 (SQL Overall)1786911088.20221786.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.