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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

109 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
nilgau73511(None) 
nilgai734881nilgai
nilgaus844001nilgaus
nilghau1142431nilghau
nilgais845202nilgais
nilghai1142472nilghai
nilghaus1242302nilghaus
nylghau1441412nylghau
pilau73618522pil_au
alga57927603_alga_
algae65319623_algae
algal66518223_algal
algas65624933_algas
belga8313233belga_
belgas9311713belgas
bilge87618913bilg_e
bilged105513183bilged
bilges94915633bilges
bilgy114713713bilg_y
biogas94310913biogas
cigar8911803ci_gar
cilia73016763cilia_
fila74729133fil_a_
filar84819293fil_ar
filial93013253filial
giga66720943gi_ga_
gigas75415583gi_gas
gingal81010153gingal
hila76228353hil_a_
hilar85418143hil_ar
iglu510814783_i_glu
ilea45931463_ilea_
ileac75814173_ileac
ileal56118083_ileal
ilia46026823_ilia_
iliac75013493_iliac
iliad64613463_iliad
ilial55317843_ilial
ilka87215153_ilka_
inlay85214323inl_ay
jingal1498593jingal
ligan67920283li_gan
lilac7311073lil_ac
linga66820823linga_
lingam95112353lingam
lingas75116573lingas
lingua7509913lingua
luau44824163__luau
milage93414123milage
milia72719573milia_
milieu8314113milieu
milpa92111403milpa_
milpas101710273milpas
nala46930393nal_a_
nalas55528363nal_as
nicad8312613ni_cad
nidal65217103ni_dal
nidget83715643nidget
niggard1044943niggard
nigger89713573nigger
niggle83612823niggle
niggly11418913niggly
nigh85220663ni_g_h
nighs95013613ni_ghs
night94327853ni_ght
nil36144193nil___
nilghais1242903nilghais
nill45634303nil__l
nilled73919453nilled
nills54926673nil_ls
nils46132453nil__s
ninja1258093ninja_
ninjas1386303ninjas
nipa69421633ni_pa_
nipas77116673ni_pas
nival84915773ni_val
nizam16310253ni_zam
nongay10169153nongay
nougat74712653nougat
nullah9388143nullah
nylghai1441443nylghai
nylghaus1551393nylghaus
oilcan837793oilcan
oilman839483oilman
oilway1235743oilway
pilaf103923483pil_af
pilar75221503pil_ar
pilaus84114133pil_aus
pilaw103913743pil_aw
pilea75123953pilea_
pillar8314023pillar
sigla64515203sigla_
silage72715303silage
silva82714023silva_
silvae92811093silvae
silvan92810153silvan
silvas92912183silvas
tilak91011553til_ak
unialgal942693unialgal
viga85622963vi_ga_
vigas94817883vi_gas
villa85321233villa_
villae95615383villae
villas96117263villas
virga9310253virga_
virgas1048883virgas
vulgar10426823vulgar
wigan95114393wi_gan
zillah1836563zillah

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.376475242.0
2DLD Change Limit1127161094.87323130.7
3Display Results1091090.0333303.0
 (SQL Overall)1786911095.28233830.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.