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

45 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
jemadar174337(None) 
jemadars1842541jemadars
jemidar1744161jemidar
bemadam1445772bemadam
jemidars1843422jemidars
armada938783armada_
armadas1038173armadas
beader94623793be_ader
bemadams1543383bemadams
bemata10411693bemata_
cedar84014323ce__dar
chadar1239353_chadar
deader84220473de_ader
decadal1137243decadal
demander12238723demander
deodar837713de_odar
embar94011603_em_bar
evader1036813_evader
gelada837623gelada_
geladas936313geladas
hamada1239923hamada_
hamadas1339673hamadas
header104422543he_ader
hematal1238953hematal
jacamar1844323jacamar
jehad1637683jehad__
jehads1735833jehad_s
leader74824653le_ader
maar66025063__ma_ar
madam10316223__madam
makar115614973__makar
malar76424443__malar
megabar1244503megabar
radar61316723__radar
ramada9310183ramada_
ramadas1039303ramadas
reader73628293re_ader
remade94316983remad_e
remaker133813173remaker
remuda936823remuda_
remudas1035833remudas
seminar979763seminar
subadar10125583subadar
templar1145643templar
zemindar2043323zemindar

Search took 7 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.393454684.5
2DLD Change Limit134027455.75023309.0
3Display Results45450.0301500.0
 (SQL Overall)178691456.17328947.2
 
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.