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

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

66 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
calif10492910(None) 
alif76242141_alif
calf96339561cal_f
califs114915891califs
calix145317351calix
kalif125021361kalif
aalii5316132aalii
alef76340692_alef
alifs86121262_alifs
alit46155692_alit
cabin94820942cabin
cadi75732182cadi_
cadis84428502cadis
caff125631672ca_ff
caid77837532ca_id
cain65643912ca_in
calcic9311872calcic
calcify1735872calcify
calfs104919382calfs
calico103414432calico
caliph13311402caliph
calk105527662cal_k
calkin123515492calkin
calks115421602calks
call66838672cal_l
calla74827072calla
calls75634732calls
calm85032362cal_m
calms95222352calms
calo64936442cal_o
calos74431902calos
calve105919922calve
calx135722792cal_x
calyx17518192calyx
canid85526342canid
capiz18514562capiz
caplin103216302caplin
carlin84421822carlin
catlin83819082catlin
caulis85320082caulis
cavie104621592cavie
cavil103816492cavil
cilia73016762cilia
claim95616912claim
clef97028182c_lef
cliff135917132c_liff
clift106422192c_lift
clip86924002c_lip
coalify1536682coalify
coif96337912c_oif
colic95726172colic
colin76231692colin
cuif96529142c_uif
cylix17448622cylix
half106238452hal_f
halid94424982halid
kaif116933932ka_if
kalifs134410982kalifs
khalif1657832khalif
malic94525662malic
naif76839022na_if
salic73424712salic
salify12311372salify
tali46837162tali_
valid94618392valid
waif105836752wa_if

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit53800661.45337026.8
3Display Results66660.0135076.9
 (SQL Overall)178691661.779100444.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.