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

217 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
cassinas10361063(None) 
cassenas10317481cassenas
cassias93514341cassi_as
cassina94113161cassina_
cassines103116611cassines
cassinos10309351cassinos
cantinas102713772cantinas
carinas93622402ca_rinas
caseins93115052casein_s
casings104013512ca_sings
casinos93512832ca_sinos
casitas93312042ca_sitas
cassabas1245732cassabas
cassatas1036682cassatas
cassavas1344802cassavas
cassena9287842cassena_
cassenes103611292cassenes
cassia83714762cassi_a_
cassine93817282cassin_e
cassino93512432cassin_o
cassis84818852cassi__s
cassises103811742cassises
castings113614052castings
gassings10438402gassings
passings11409872passings
pastinas103712152pastinas
anginas8310953_anginas
arsines73518813_arsines
asanas6514113_a_sanas
askings12519173_askings
assents74512223_assents
assignat945683_assignat
assignats1044003_assignats
assigns836193_assigns
assists738473_assists
assizes1638453_assizes
bashings144311243bashings
basinal9310033ba_sinal
basins85722763ba_sin_s
bassinet10312843bassinet
bassinets1146323bassinets
bassists1037183bassists
bastings114214693bastings
brassicas1344053brassicas
bussings11386663bussings
cabanas112413033ca_banas
cabins104418923ca_bin_s
caesiums1245533caesiums
caesuras1055733caesuras
cains75334303ca__in_s
caissons1036283caisson_s
calcines12314753calcines
calkings15289223calkings
calkins133814873calkin_s
callings113613833callings
camisas113411923ca_misas
camisias12268603camisias
campings154010203campings
candidas12338643candidas
canines93724033ca_nines
cannas84518403ca__nnas
cannings113710333cannings
cantina93417253cantina_
canzonas1935383canzonas
capias10318353ca_pi_as
caplins113515993caplin_s
cappings15369493cappings
capsidal1345623capsidal
capsids1239333capsi_ds
capsizes2147203capsizes
capstans1257243capstans
carbines123617533carbines
cardias10715113cardi_as
cardinal1139563cardinal
cardinals1247993cardinals
cardings123812633cardings
carina84325323ca_rina_
carinae94318583ca_rinae
carinal94318233ca_rinal
caritas93316953ca_ritas
carlines103521643carlines
carlings114015853carlings
carlins93921913carlin_s
carmines123617863carmines
carpings133812383carpings
carvings143810203carvings
casabas1139983ca_sabas
casas75327843ca_s__as
casavas1237823ca_savas
cascaras1237703cascaras
casein83216453casein__
caseinate1148243caseinate
caseinates1247443caseinates
casernes103810753casernes
caserns94711223casern_s
cashiers13318883cashiers
cashing135022553cashin_g
casing94829103ca_sin_g
casini84615863ca_sin_i
casino84317553ca_sin_o
casita82913703ca_sita_
casking144317353caskin_g
cassaba1145663cassaba_
cassata938143cassata_
cassava1255003cassava_
cassene93111543cassen_e
cassingle1244103cassingle
cassingles1342993cassingles
cassocks1645033cassocks
casting104628343castin_g
casuarinas1243043casuarinas
casuists1036523casuists
catenas9313113ca_tenas
catkins133012563catkin_s
catlings113712043catlings
catlins93818843catlin_s
catmints1236663catmints
causing103614413causin_g
cavatinas1444783cavatinas
cavings134712543ca_vings
cessing103814813cessin_g
cessions1039853cessions
chasings14318253chasings
chassis123910663chassi__s
chinas115119403c__hinas
cissies94116153cissi_es
classical1345293classical
classicals1443903classicals
classics12418873classi_cs
classiness12196313classiness
classing113211793classin_g
classis93712723classi__s
classisms13295523classisms
classists11296243classists
classons1037703classon_s
closings11277673closings
coassists11275763coassists
coastings12357863coastings
codeinas11338023codeinas
coquinas1944783coquinas
corbinas12229393corbinas
cortinas102212443cortinas
corvinas13238013corvinas
cosines94122673c_osines
cousins9516003cousin_s
crossings12217163crossings
cuisines1049373cuisines
cussing103814273cussin_g
cystines1339473cystines
czarinas1935293czarinas
dassies84418663dassi_es
eastings93412953eastings
farinas103215233fa_rinas
fascias1258413fasci_as
fascines13310143fascines
fastings124011943fastings
gaskings14427473gaskings
gaskins123510773gaskin_s
gassiness10268313gassiness
gassing94216333gassin_g
glassines10278043glassines
glossinas10214143glossinas
hassiums1344273hassiums
hessians1145053hessians
hissings12556753hissings
jarinas143712183ja_rinas
jasmines1736623jasmines
jasmins1637083jasmin_s
jassids1586143jassi_ds
kachinas1736343kachinas
kamsins1346963kamsin_s
katcinas1434513katcinas
laminas93615873la_minas
lasagnas943673lasagnas
lashings124412253lashings
lashins103915153lashin_s
lassies74420103lassi_es
lassis65216703lassi__s
lastings94214423lastings
latinas74416463la_tinas
marinas93519383ma_rinas
maskings15448753maskings
massas85116463mass__as
massifs1237743massi_fs
massiness112810143massiness
massing104318023massin_g
nandinas936573nandinas
ocarinas1036723oca_rinas
paisanas10288873paisanas
pashminas1642903pashminas
passing104318423passin_g
passional1146043passional
passionals1244803passionals
passions10310583passions
passives13228823passives
pastina93914593pastina_
patinas96318523pa_tinas
piscinas1275483piscinas
quassias1754933quassi_as
quassins1735793quassin_s
raisings9338443raisings
raisins72715343raisin_s
raspings11337853raspings
retsinas8387963retsinas
salinas73116093sa_linas
sarcinas1039273sarcinas
sasins64923103sa_sin_s
sassies74719263sassi_es
sassiness8249333sassiness
sassing84615553sassin_g
sestinas8249133sestinas
tarsias74013373tarsi_as
tassies74918933tassi_es
tsarinas835273tsarinas
vaccinas1544973vaccinas
vaginas11298813va_ginas
washings15419273washings

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 Filter1786911461620.453394461.4
2DLD Change Limit1461622176.87621256.8
3Display Results2172170.0932333.3
 (SQL Overall)1786912177.42224075.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.