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 “laura” with Change Limit: [1] [2] [3]

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
laura5411620(None) 
aura45836251_aura
labra75415461labra
laurae64011661laurae
lauras63414331lauras
alula5317092alula
aurae54128112_aurae
aural54428962_aural
aurar54420252_aurar
auras55932552_auras
bura66139532_bura
crura7312582crura
datura738022datura
doura66518662doura
dura55232112_dura
fauna84816512fauna
flauta937822flauta
gaur56723352gaur_
gaurs66317992gaurs
jagra1338172jagra
jura116024892_jura
kauri93811852kauri
kaury12429762kaury
laari54415712laari
labara83712892labara
labia75219012labia
lacuna8118122lacuna
laguna7127222laguna
lahar83114262lahar
lair45934152lair_
laird65417792laird
lairs55425872lairs
lama66635292la_ma
lamia75324322lamia
lar37967532la_r_
lard56742002la_rd
lari45839152la_ri
lark85733862la_rk
lars46956572la_rs
larum74317972larum
larva8312482larva
latria62313592latria
lauan55216792lauan
laud56527722lau_d
lauds65618482lauds
laugh94414372laugh
laurel649032laurel
lava76725422la_va
lazar144113642lazar
libra74712422libra
lira46928682l_ira
louma76213632louma
lour45430682lour_
lours55125292lours
loury85716752loury
luma65527522l_uma
luna46229852l_una
lure45142462l_ure
lurk86624162l_urk
lycra10317972lycra
mara67444572ma_ra
mura65633292_mura
naira5314742naira
para65242172pa_ra
parura8310582parura
pleura837532pleura
sabra75317852sabra
sacra74516992sacra
sauna54117552sauna
saury84317222saury
sura45740292_sura
vara75530882va_ra
waur76819902waur_

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit53800731.50035866.7
3Display Results73730.0164562.5
 (SQL Overall)178691731.609111057.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.