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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

90 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
lav66847341l_av
luau44824161luau
luv67125771lu_v
duad66521412duad
dual55928172dual
guan55325582guan
guar56923292guar
guava938582guava
guv74523172gu_v
la219261632l_a_
lab58864782l_ab
lac510155822l_ac
lad48165702l_ad
lag47862122l_ag
lam57666712l_am
lap58565272l_ap
lar37967532l_ar
las37281472l_as
lat37593402l_at
lauan55216792lauan
laud56527722laud
lava76725422l_ava
lave75642142l_ave
lavs76734152l_avs
law68656642l_aw
lax107651522l_ax
lay68865352l_ay
lea37660182lea_
lead56038852lead
leaf76441032leaf
leak86233712leak
leal46043272leal
lean46345242lean
leap66032682leap
lear47045952lear
leas45954182leas
leave84723722leave
leavy115715772leavy
lev66139422l_ev
leva77020712leva
liar47229682liar
load56730602load
loaf76734902loaf
loam65630482loam
loan47436452loan
luaus54514902luaus
lube64731562lube
luce65132572luce
luck105329822luck
lude55331642lude
lues45943552lues
luff104426702luff
lug46138062lu_g
luge55531642luge
lugs55233522lugs
lull44225762lull
lulu44122882lulu
lum55542932lu_m
luma65527522luma
lumas75622912lumas
lump86531702lump
lums65734242lums
luna46229852luna
lunar57017312lunar
lunas55025012lunas
lune47140492lune
lung55732492lung
lunk86030722lunk
lunt46148842lunt
luny77324132luny
lure45142462lure
lurk86624162lurk
lush75327692lush
lust47442602lust
lute46341012lute
lutz136826322lutz
luvs75818502luvs
lux106528772lu_x
luxe115222692luxe
qua124821972qua_
quad144618702quad
quag144815942quag
quai134420392quai
quay164618352quay
suave83519872suave
tav66043212_tav
ulan46527392ulan
ulva75412692ulva
vav95829432_vav
yuan76120012yuan

Search took 1 second 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 Filter178691298720.0802233637.5
2DLD Change Limit29872900.87334217.6
3Display Results90900.0165625.0
 (SQL Overall)178691900.969184407.6
 
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.