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

65 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
yakuza226187(None) 
makuta1236392makuta
abuzz15517213_abuzz
ajuga1335883_ajuga
akela9311343_akela
alula5317093_alula
aqua132813963_aqu_a
aura45836253_a_ura
bacula103112673bacula
baiza164813223ba_iza
canula8312963canula
datura738023datura
facula112912233facula
fauna84816513fa_una
gauze155712973ga_uze
gauzy18489213ga_uzy
haku116923893haku__
hakus125114113haku_s
hamza19139773ha_mza
kahuna1394103kahuna
kaka76518683kak__a
kuna85120703__kuna
lacuna8118123lacuna
laguna7127223laguna
laura54116203la_ura
likuta1034213likuta
macula103013673macula
matza16311813ma_tza
mazuma1935603mazuma
mezuza1643533mezuza
nakfa1236093nak_fa
oakum1177313oaku_m
oakums1264153oakums
pakeha1533933pakeha
pakora1247283pakora
papula103011113papula
parura8310583parura
radula749313radula
raku85423773raku__
rakus94413673raku_s
ranula6311813ranula
sauna54117553sa_una
skua86113153_sku_a
taka87623593tak__a
taluka10426773taluka
tazza1338083ta_zza
vacua10510463vacu_a
valuta938743valuta
yak107038563yak___
yakked13366093yakked
yakker12405533yakker
yaks116025203yak__s
yamulka1651773yamulka
yamun10419273yamu_n
yamuns11336513yamuns
yantra9449623yantra
yaud87020083ya_u_d
yauds95013223ya_uds
yauld95511183ya_uld
yaup96618483ya_u_p
yaups105910743ya_ups
yautia937253yautia
yuca95716723y__uca
yuga85615423y__uga
zanza1378703za_nza

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit112716655.17321789.3
3Display Results65650.0164062.5
 (SQL Overall)178691655.56232127.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.