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

55 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
casimere125479(None) 
cashmere1564321cashmere
casimeres1355191casimeres
casimire1244771casimire
cassimere1343701cassimere
capsomere1543362capsomere
cashmeres1654392cashmeres
casimires1344692casimires
cassimeres1443592cassimeres
chimere144010632c_himere
aimer75926823_a_imer_
aimers84621913_a_imers
antimere10410683antimere
cagier93715933cagi_er_
cahier113615773cahi_er_
cahiers123510673cahi_ers
cakier123115243caki_er_
caliber1139733caliber_
calibers1238523calibers
calibre1136603cali_bre
calipee11412913calipe_e
caliper11410963caliper_
calipered1454873calipered
calipers1249443calipers
calmer105216933ca_lmer_
camera10313673ca__mera
camerae11312043ca__merae
capsomer1445773capsomer_
capsomeres1643353capsomeres
capsomers1544753capsomers
casemate1239843casemate
casement12311953casement
casern84713313cas__ern
caserne93710063cas__erne
cashier123713323cashier_
cashiered1543403cashiered
cashiers13318883cashiers
cassene93111543cas_sene
caster85232573cas_ter_
casters94729893cas_ters
caviare1238373cavi_are
caviler1249063caviler_
cavilers1348113cavilers
chimer135517203c_himer_
chimera14389263c_himera
chimeres153511303c_himeres
chimers144515133c_himers
claimer11279883claimer_
claimers12298743claimers
cosier84423753cosi_er_
easier64218463easi_er_
epimere1186983_epimere
maimer104514593ma_imer_
maimers113813043ma_imers
mesomere1247193mesomere

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.1561145455.1
2DLD Change Limit146162558.51617163.2
3Display Results55550.0163437.5
 (SQL Overall)178691558.68820567.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.