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 “cambiums” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
cambiums164493(None) 
cambisms1645801cambisms
cambium1537321cambium_
cadmiums1544402cadmiums
caesiums1245532caesiums
calciums1446162calciums
cambism1538032cambism_
cambists1437022cambists
albums10198273_alb_ums
alliums957973_alliums
ambits103713413_ambi_ts
amylums1473613_amylums
atriums939043_atriums
bambinos1443873bambinos
bariums1139143ba_riums
cabbies133115163cabbi_es
cabins104418923ca_bi_ns
cadmium1446113cadmium_
caesium1158833caesium_
caladiums1444633caladiums
calcium1368593calcium_
camails11311753camai_ls
cambers134017443camb_ers
cambia124913153cambi__a
cambial134010763cambi_al
cambist13312113cambi_st
cambrics1645253cambrics
camions113916133cam_ions
camisas113411923cam_isas
camises114218463cam_ises
cammies134016483cammi_es
campings154010203campings
campions143511293campions
campouts1436823campouts
campus125213923cam_pu_s
capsicums1742383capsicums
carbides133111693carbides
carbines123617533carbines
carboniums1645183carboniums
catbirds1344203catbirds
ceriums1139473c_eriums
cesiums1136303c_esiums
columbiums1852633columbiums
combines142814623combines
combings15348323combings
coniums11311863c_oniums
craniums1297913craniums
crumbums1642733crumb_ums
cubisms13306883c_ubisms
cumbias13338963cumbi_as
curiums1138503c_uriums
cymbidiums2251283cymbidiums
erbiums1135463_erbiums
galliums1145963galliums
gambias125010733gambi_as
gambiers13337073gambiers
gambirs12359083gambi_rs
gambits12399723gambi_ts
hafniums1643103hafniums
hahniums1643343hahniums
hassiums1344273hassiums
iambics13425643iambi_cs
iambus10468903iamb_u_s
kaliums1336603ka_liums
labium10410243la_bium_
labrums1175853la_brums
lambies113015113lambi_es
natriums1046293natriums
niobiums1243373niobiums
osmiums1134143osm_iums
pablums1345123pa_blums
palliums1236703palliums
procambiums2151673procambiums
radiums10299313ra_diums
samariums1345133samariums
sambhurs1543183sambhurs
samburs11369343samb_urs
scandiums1443983scandiums
stibiums1244203stibiums
tambours1255873tambours
tamburs11288613tamb_urs
terbiums1245423terbiums
wampums16314213wam_pums

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.423422437.4
2DLD Change Limit146162837.14020470.9
3Display Results83830.0332515.2
 (SQL Overall)178691837.59623524.4
 
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.