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

256 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
casbah133790(None) 
casbahs1436461casbahs
kasbah1535181kasbah
cabal95222152ca_bal
casa65630862cas_a_
casaba1079262casaba
casabas1139982casabas
casas75327842cas_as
cash96636282cas__h
cashaw14439792cashaw
casual81112862casual
gasbag1035412gasbag
kasbahs1634362kasbahs
aah616252963_a__ah
aba512850953_a_ba_
abas68642083_a_bas
abash106016513_a_bash
abba810522653_abba_
abbas95918643_abbas
alba68328333_alba_
albas75925393_albas
almah106917253_almah
amah98927493_a_mah
asea46327183_asea_
ash67944603_as__h
assai5711543_assai
assay8710283_assay
ayah108022993_a_yah
baba88828353ba_ba_
babas96325733ba_bas
bah87755353___bah
baobab946403baobab
barbal104016663barbal
basal75722283bas_al
bash915240163bas__h
bashaw14349303bashaw
busbar1038453busbar
cab78355403ca_b__
cabala103516913ca_bala
cabals104020153ca_bals
cabana103913563ca_bana
cabbage1446983cabbage
cabbagy1744013cabbagy
cabbala1367183cabbala
cabbalah1763793cabbalah
cabbed135416263cabbed
cabbie122913353cabbie
cabby145314563ca_bby
caber95126833ca_ber
cabin94820943ca_bin
cable95329913ca_ble
cabman123812503cabman
cabob114616813ca_bob
cabs86739423ca_b_s
caca85528083ca_ca_
cacao95420003ca_cao
cacas95627983ca_cas
caeca93915133caeca_
caecal103713733caecal
caesar8410933caesar
caftan111710123caftan
caiman103615663caiman
calabash1544253calabash
calash11312433calash
calcar10312753calcar
caliph13311403caliph
calla74827073calla_
callan83619603callan
callas84526753callas
calpac123211063calpac
camas96333523ca_mas
camber124418483camber
cambia124913153cambia
cambial134010763cambial
canal75428043ca_nal
cancan10314103cancan
cancha134411613cancha
canna75919333canna_
cannas84518403cannas
cantal84122033cantal
canvas113813333canvas
caph116623293ca__ph
capias10318353capias
capstan1137903capstan
captan101613343captan
carabao1139673carabao
carat75048793ca_rat
carb85143163carb__
carbarn1139453carbarn
carbo94923843carb_o
carbon104919043carbon
carbos105122263carbos
carboy134914183carboy
carbs96031463carb_s
carman103920743carman
carnal83919213carnal
caroach1488863caroach
caroch13911763caroch
carpal103716253carpal
carwash1536003carwash
casava1157873casava
casavas1237823casavas
cascade12118603cascade
cascara1138313cascara
case65848083cas__e
casease939323casease
caseate9314783caseate
cased86032413cas_ed
casefy1436273casefy
caseic103212373caseic
casein83216453casein
casern84713313casern
cases75048383cas_es
cashaws15398573cashaws
cashbox2143453cashbox
cashed125124353cashed
cashes114729883cashes
cashew144311453cashew
cashoo11312253cashoo
casing94829103casing
casini84615863casini
casino84317553casino
casita82913703casita
casitas93312043casitas
cask105626433cas__k
casked134815513casked
casket124820993casket
casks115720063cas_ks
casky144512683cas_ky
casque17299273casque
cassaba1145663cassaba
cassabas1245733cassabas
cassata938143cassata
cassava1255003cassava
cassia83714763cassia
cassias93514343cassias
cassis84818853cassis
cast67159903cas__t
caste75932363cas_te
caster85232573caster
castes85631863castes
castle84918963castle
castor84418533castor
casts77237793cas_ts
casuals91410533casuals
casus76419253cas_us
catboat11412243catboat
catch125120373ca_tch
catnap1098383catnap
catspaw1443353catspaw
caudad10157673caudad
caudal91611483caudal
causal81413203causal
caveat11417723caveat
caviar11310163caviar
cayman133613213cayman
ceiba938703ceiba_
ceibas1038503ceibas
cesta75419483cesta_
cestas85018543cestas
chalah143511663chalah
challah15458323challah
chasmal14158213chasmal
chetah14399583chetah
clash106219033clas__h
coastal9411043coastal
combat12316753combat
coprah133710603coprah
corban10314693corban
cosh96127623cos__h
costa75523733costa_
costae85319683costae
costal85419513costal
costar85518613costar
crash109120013cras__h
cushat113513693cushat
cushaw14386983cushaw
cuspal1037883cuspal
cymbal15236913cymbal
darbar959953darbar
dash87031633das__h
disbar938513disbar
fash107232293fas__h
galah95917643ga_lah
gamba106018513gamba_
gambas115817513gambas
ganjah17145503ganjah
gasbags1135473gasbags
gash86833023gas__h
gasman92911743gasman
hallah124115403hallah
halvah15499833halvah
hamzah23135563hamzah
hash106936503has__h
isba61310883_isba_
isbas71010403_isbas
jarrah1636683jarrah
jubbah2034353jubbah
kabab134814443ka_bab
kabar114815553ka_bar
kanban1238623kanban
kasha124710723kasha_
kashas133311903kashas
lascar868573lascar
lash76539653las__h
mamba116317523mamba_
mambas125716243mambas
masa65034723mas_a_
masas75630413mas_as
mash96039403mas__h
massa75518923massa_
massas85116463massas
mastabah1554023mastabah
matsah1138233matsah
matzah2035963matzah
nasal56217593nas_al
nasial6413283nasial
padshah16113353padshah
pardah123412823pardah
pariah114320583pariah
pascal10812373pascal
pash95638133pas__h
pasha105417183pasha_
pashas115117063pashas
pasta76624533pasta_
pastas85422873pastas
rabat72832223ra_bat
ragbag1045463ragbag
rajah155711423ra_jah
rascal8511123rascal
rash76039933ras__h
ratbag956563ratbag
rayah116013503ra_yah
sabal75422483sa_bal
sabbat10314713sabbat
sabbath1445393sabbath
samba95618773samba_
sambal105215183sambal
sambar103914163sambar
sambas104219263sambas
sash77235303sas__h
sashay1238363sashay
shah105627783__shah
shibah14387473shibah
subah106015213_subah
tambac122210243tambac
tambak14249263tambak
taskbar1393023taskbar
tussah9356233tussah
vasa76522973vas_a_
vasal85516293vas_al
vassal979243vassal
wallah124011993wallah
wasabi1154643wasabi
wash106033813was__h
yasmak1534593yasmak

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162565.07622205.7
3Display Results2562560.0803200.0
 (SQL Overall)1786912565.54632219.8
 
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.