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

73 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
moujiks206251(None) 
moujik1962881moujik_
mujiks1964021m_ujiks
moulins9312702moulins
mujik1866102m_ujik_
muzjiks2982502muzjiks
boudins10311313boudins
bougies103715183bougies
coulis84018753couli_s
cousins9516003cousins
crojiks2033173crojiks
fujis15379243_fuji_s
houris94514563houri_s
jouks165612343jou__ks
kojis16468433ko_ji_s
koumis1237613koumi_s
koumiss1344313koumiss
louies64525103lou_ies
louis57322323lou_i_s
masjids17175403masjids
mocks135023823mo__cks
moggies113111723moggies
mohairs1234953mohairs
mohawks1942123mohawks
moils76125753mo__ils
mojoes15399523mo_joes
mojos145314463mo_j_os
molies84429513mo_lies
mollies93420233mollies
mommies103912273mommies
monies83233163mo_nies
monks116123393mo__nks
morris83814723morri_s
mosaics1138073mosaics
mosks116117003mo__sks
motifs1139673mo_tifs
mouches143815963mouches
moues75732843mou__es
moulds94910993mou_lds
moulin8313283mouli_n
moults84713703mou_lts
mounds93915133mou_nds
mounts84115073mou_nts
mourns84111013mou_rns
mousaka1343173mousaka
mousakas1442733mousakas
mousers95216443mousers
mouses85531423mou_ses
mousier93712463mousier
mousiest102711763mousiest
mousily1239393mousily
mousing103816273mousing
mousings11277703mousings
mousses94012703mousses
mouths115214533mou_ths
moutons9410313moutons
movies115118453mo_vies
moxies154317403mo_xies
mucins102712513m_ucins
mucks134622643m_u_cks
munis75022003m_uni_s
murids93212193m_urids
murks114821723m_u_rks
musicks15297053m_usicks
musics103911783m_usics
musjids17185713musjids
musks116119643m_u_sks
muzhiks2573093muzhiks
muzjik2872703muzjik_
souks94820523sou__ks
sousliks1244003sousliks
tupiks1235493_tupiks
zouks184410503zou__ks

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.1561145455.1
2DLD Change Limit134027737.42318055.6
3Display Results73730.0135615.4
 (SQL Overall)178691737.59223536.7
 
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.