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

52 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
muzjiks298250(None) 
mujiks1964021mu_jiks
muzhiks2573091muzhiks
muzjik2872701muzjik_
moujiks2062512moujiks
mujik1866102mu_jik_
musjids17185712musjids
muzhik2473522muzhik_
buzukis2242663buzukis
crojiks2033173crojiks
fujis15379243fu_ji_s
fuzils18407963fuz_ils
masjids17175403masjids
moujik1962883moujik_
mucins102712513mu_cins
mucks134622643mu__cks
mucoids1237423mucoids
muddies113513953muddies
muezzins1842663muezzins
muffins15308343muffins
muftis1158053mufti_s
muggins11248073muggins
muhlies1238933muhlies
mukluks1242413mukluks
muktuks1242253muktuks
mummies103812843mummies
munis75022003mu_ni_s
muntins92715133muntins
muntjaks2142003muntjaks
mureins9310733mureins
murids93212193mu_rids
murks114821733mu__rks
murries94118673murries
muscids12187973muscids
musicks15297053musicks
musics103911783mu_sics
musjid16216953musji_d
muskies133614673muskies
muskits13278563muskits
musks116119643mu__sks
muslins9312213muslins
muspike1536043muspike
muspikes1635243muspikes
muzzier17326553muzzier
muzziest18175833muzziest
muzzily2045023muzzily
muzzles17299683muzzles
nudniks1262333nudniks
punjis1536693punji_s
susliks1136443susliks
tugriks1233153tugriks
tupiks1235493tu_piks

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.423422437.4
2DLD Change Limit134027525.65623696.4
3Display Results52520.0134000.0
 (SQL Overall)178691526.09229332.1
 
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.