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

76 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
chiasmi1436558(None) 
chiasm13449101chiasm_
chiasma14366991chiasma
chiasmic17295021chiasmic
chiasms14357521chiasms
chasm125518792ch_asm_
chasmic16177982ch_asmic
chasms135513142ch_asms
chasmy16468542ch_asmy
chianti1236612chianti
chias104625522chias__
chiasmal15285032chiasmal
chiasmas15306592chiasmas
chiasmus15343912chiasmus
chiastic15287482chiastic
calami10313423cala_mi
chacma1537903ch_acma
chadri1238143ch_adri
chai95929903ch_a__i
chais107530313chais__
chaise114916413chais_e
chaises124317493chaises
cham115532313ch_a_m_
chammy18488953ch_ammy
champ145017963ch_a_mp
chams126028503ch_a_ms
charm126124663ch_arm_
charms135218843ch_arms
chase105127123ch_as_e
chased125019293ch_ased
chaser114918383ch_aser
chases115128233ch_ases
chasmal14158213ch_asmal
chasmed154710173ch_asmed
chasse115114603ch_asse
chassis123910663ch_assis
chaste114617393ch_aste
chia96026623chia___
chiantis1346593chiantis
chiao105618363chia__o
chiasmata1643073chiasmata
chiasmatic1954343chiasmatic
chiaus113611313chia_us
chiauses1336483chiauses
chicas135916473chicas__
chichi1637093chi_chi
chics123920943chics__
chili106218483chi__li
chiliasm15134513chiliasm_
chiliasms1693493chiliasms
chilli114312773chi_lli
chimb144813563chi__mb
chime125322593chi__me
chimp145216473chi__mp
chinas115119403chinas__
chins105631463chins__
chips125721253chips__
chirm125317063chi_rm_
chirms135113983chi_rms
chis95933313chi_s__
chisel112111943chi_sel
chits105424573chits__
chivari1536043chivari
chloasma1542963chloasma
chrism13710673chrism_
chrisma1456823chrisma
chrisms1499143chrisms
miasm91211093_miasm_
miasma1097563_miasma
miasmic1335743_miasmic
miasms1097383_miasms
ohias84415573ohias__
phasmid15267603ph_asmid
schism1338173schi_sm_
schisms1437173schi_sms
thiamin1236933thia_min

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.423422437.4
2DLD Change Limit134027766.95319276.1
3Display Results76760.0135846.2
 (SQL Overall)178691767.38924183.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.