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

116 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
craniums129791(None) 
cranium11911101cranium_
uraniums10117161uraniums
coniums11311862c_oniums
crinums1135862crin_ums
franciums1644412franciums
geraniums1245252geraniums
radiums10299302_radiums
uranisms1099972uranisms
uranium9610022uranium_
actiniums1395843actiniums
animus84211613__animus
arcanums1274163arcan_ums
bariums1139143_bariums
cadmiums1544403cadmiums
caesiums1245533caesiums
caladiums1444633caladiums
calciums1446163calciums
cambiums1644923cambiums
canfuls1248423c_anfuls
cangues10611823c_angues
canids95118133c_ani_ds
canines93724033c_anines
cantus85117763c_antu_s
carboniums1645183carboniums
carnies94123963carni_es
centums11398783c_entums
ceriums1139473c_eriums
cesiums1136303c_esiums
charisms15710263charisms
chromiums1844533chromiums
cladisms1336093cladisms
claims105211573cla_i_ms
clonisms1237793clonisms
conium10415313c_onium_
corundums1442563corundums
crackups1843123crackups
crams96229153cra___ms
cranches153114543cranches
cranes84330753cran__es
crania82418433crani__a
cranial92114683crani_al
craniate10312563craniate
craniates11310653craniates
craning103620303crani_ng
crankles143510153crankles
crankous1435973crankous
cranks125015313cran__ks
crannies10313013crannies
crannogs1143783crannogs
crasis85020473crasi__s
cravings14428213cravings
crazies183413853crazi_es
crinites10612753crinites
crinum1039333crin_um_
cronies9622503croni_es
cronyisms1643813cronyisms
crumbums1642733crumbums
cundums1235183c_undums
curiums1138503c_uriums
cyanides14258003cyanides
cyanids13297933cyani_ds
cyanines132710543cyanines
cyanins122910013cyani_ns
cyanites132610153cyanites
czarisms2155753czarisms
dubniums1343153dubniums
erbiums1135463er_biums
fanums1137263_fan_ums
fraenums1353403fraenums
francium1545623francium_
frenums1236203fren_ums
geranium1147053geranium_
germaniums1543863germaniums
grandams1237123grandams
granitas92610223granitas
granites92116363granites
granum9310913gran_um_
hafniums1643103hafniums
hahniums1643343hahniums
ioniums938303_ioniums
iridiums1144523iridiums
kaliums1336603_kaliums
miniums113910213_miniums
muoniums1244723muoniums
nanisms938833_nanisms
onanisms1048063onanisms
oralisms10610973oralisms
organisms1247213organisms
organums1143883organ_ums
panicums1444743_panicums
pianisms1249013pianisms
premiums1437533premiums
protiums1238553protiums
racisms112310813_racisms
radium93513293_radium_
radius73914863_radiu_s
randoms102112433_randoms
ranids75118703_rani_ds
ranis55235833_rani__s
ransoms92410163_ransoms
rheniums1344413rheniums
scandiums1443983scandiums
stadiums1145703stadiums
stannums1043803stannums
titaniums1144763titaniums
trangams1147183trangams
transoms1048933transoms
trinkums1443403trinkums
tritiums1056393tritiums
uranias72113813urani_as
uranides92211283uranides
uranism91112513uranism_
uranites82514643uranites
uranous7310723uranou_s
urbanisms13115993urbanisms

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.1731032896.0
2DLD Change Limit1461621168.06018134.2
3Display Results1161160.0462521.7
 (SQL Overall)1786911168.27921583.6
 
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.