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

162 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
calibre113660(None) 
caliber1139731caliber
calibred1335051calibred
calibres1237101calibres
alible8311972_alible
calibers1238522calibers
calibrate1347742calibrate
caliche14329952caliche
calicle113111432calicle
calipee11412912calipee
caliper11410962caliper
caribe103416752carib_e
caviare1238372caviare
afire86215913_afi_re
albite8313313_albite
alibi7514233_alib_i
alibied1038143_alibied
alibies9313323_alibies
alibis8311073_alibis
alike95523963_ali_ke
aline57243153_ali_ne
aliner65621983_aliner
alive85722513_ali_ve
allure63012943_allure
cabbie122913353ca_bbie
caber95126833ca__ber
cable95329913ca__ble
cacique20205693cacique
cadre85419023ca__dre
cagier93715933cagier_
cahier113615773cahier_
cahiers123510673cahiers
caique17318803ca_ique
caird85717233ca_i_rd
cairn75717513ca_i_rn
cakier123115243cakier_
calcar10312753calcar_
calcars11312653calcars
calcine11315273calcine
calcite11413783calcite
caldera1037963caldera
caleche14297943caleche
calibrated1545643calibrated
calibrates1446953calibrates
calices114321693calices
caliches153812263caliches
calicles123811433calicles
calico103414433cali_co
calicoes123911593calicoes
calicos113913493calicos
calif104929103cali__f
califate13310483califate
califs114915893cali_fs
calipees1247413calipees
calipered1454873calipered
calipers1249443calipers
caliph13311403cali_ph
caliphs1436753caliphs
calix145317353cali__x
calker124917083calker_
calkers134414693calkers
callable12310753callable
callboy1465833callboy
callee84327293cal_lee
caller85125483caller_
callers94221963callers
calliope1256223calliope
callipee1237733callipee
calliper1247513calliper
callose9313663callose
calmer105216933calmer_
calorie92716893calorie
calory11312843cal_ory
calotte9510563calotte
caloyer1238143caloyer
calque17289843cal_que
calvary1537183calvary
calve105919923cal__ve
calycle14245833calycle
calzone1848623calzone
camber124418483ca_mber
camise103319633cami_se
canine83826703cani_ne
capable13313363capable
capture1138913capture
carbide126112493carbide
carbine112918643carbine
care66968373ca___re
carfare12310073carfare
caribes113715643caribes
caribou1156993caribou
carinae94318593carinae
cariole9818343cariole
carline93923613carli_ne
casimere1254793casimere
casimire1244773casimire
catbird1235243catbird
catlike132712933catli_ke
caulicle1245043caulicle
cauline92215603cauli_ne
caviar11310163caviar_
caviares1337993caviares
caviars1238623caviars
cavie104621593cavi__e
caviler1249063caviler
cazique27194033cazique
celibate1259313celibate
chalice14311043chali_ce
chirre114111853c_hirre
ciliary1247923ciliary
ciliate9514603ciliate
cilice103213353cili_ce
cire65836373c__i_re
clabber134210113clabber
claimer11279883claimer
clamber133311743clamber
cliche133712453c_liche
climber13449133c_limber
clime95720893c_li_me
cline76428533c_li_ne
clique17289193c_lique
coalier93416183coalier_
colure8314163col_ure
culture939393culture
failure1035753failure
fallible1355363fallible
fibre104812843__fibre
galere73716673gal_ere
galilee8312213galilee
galore73514863gal_ore
glaire74411293glai_re
halibut1289053halibut
halide103417993hali_de
halite93624233hali_te
haltere103614703haltere
lalique1644423lalique
liber74723623__liber
libra74712423__libra
librae84310173__librae
libri74610113__libri
lire47845293__li_re
litre55421463__litre
livre85613253__livre
macabre1335223macabre
maigre9309163ma_igre
malgre9299303mal_gre
malice104818483mali_ce
maline84529083mali_ne
palabra1137183palabra
palier85023563palier_
sabre74821503sa__bre
salable91415463salable
saline65132703sali_ne
saltire73113033saltire
satire63218003sati_re
scalable121710233scalable
scalare93311833scal_are
scalier94316913scalier_
schliere1343843schliere
valine94623093vali_ne
valise92917643vali_se
zaire14311993za_i_re

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.420425454.8
2DLD Change Limit1340271626.89319443.9
3Display Results1621620.0463521.7
 (SQL Overall)1786911627.35924282.0
 
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.