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

96 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
calculi114656(None) 
calyculi1542151calyculi
calculus1255332calculus
sacculi1145042sacculi
acicula11228133acicula
aculei839793_a_culei
alkali10127563_alkali
alula5317093_al_ula
annuli6459053_annuli
apiculi1145113apiculi
bacula103112673ba_cula
bascule1136573bascule
cackle143416923ca_ckle
cacti9318643ca_c_ti
caducei1243873caducei
caecal103713733caecal_
caecum1238183caecu_m
calami10313423cal_ami
calathi1247583calathi
calcanei1265263calcanei
calcar10312753calc_ar
calcaria1249533calcaria
calcars11312653calcars
calces104420053calc_es
calcic9311873calc_ic
calcific1445023calcific
calcify1735873calcify
calcine11315273calcine
calcite11413783calcite
calcitic1148193calcitic
calcium1368593calcium
calciums1446163calciums
calctufa1552073calctufa
calctuff1842513calctuff
calculate1389873calculate
calculous1344793calculous
calicle113111433calicle
call66838673cal__l_
calla74827073cal__la
calls75634733cal__ls
callus85317073callu_s
calmly1337613cal_mly
calque17289843calqu_e
calqued19306523calqued
calques182710193calques
calycle14245833calycle
calycular1643483calycular
calyculus1642243calyculus
canaliculi1451693canaliculi
cancel105316683cancel_
cancels114113313cancels
canful11610263canful_
canfuls1248423canfuls
cannoli937263cannoli
cannula937433cannula
canula8312963ca_nula
capful1368173capful_
capfuls1436523capfuls
capsule1137343capsule
caracul1138823caracul_
caraculs1238033caraculs
carcel105018673carcel_
carcels114516063carcels
carful11610973carful_
carfuls1249133carfuls
caroli85918233ca_roli
catcall1139153catcall
caucus1039613caucu_s
caul65630003ca__ul_
cauld85318443ca__uld
caulis85320083ca__ulis
caulk115315453ca__ulk
cauls75727773ca__uls
celli76717693cel__li
cellule936523cellule
cumuli1036273c_umuli
curculio1243503curculio
facula112912233fa_cula
famuli1136763fa_muli
hamuli1137063ha_muli
lazuli1535363la_zuli
loculi8288253_loculi
macula103013673ma_cula
macule104115273ma_cule
oculi72010793__oculi
precalculi1651763precalculi
saccule1136743saccule
saluki1036203sal_uki
tabouli945843tabouli
tabuli839363ta_buli
talcum1036953talcu_m
talcums1135513talcums
valvula1343253valvula
valvule1343663valvule
vascula1245853vascula
volvuli1352083volvuli

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.1561145455.1
2DLD Change Limit134027967.20318607.1
3Display Results96960.0332909.1
 (SQL Overall)178691967.39224173.6
 
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.