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

163 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
ridgil831682(None) 
ridgel8399971ridgel
ridgils9326571ridgils
pidgin10259812pidgin
ridge75018672ridg_e
ridged94014222ridged
ridgels9348022ridgels
ridges85817012ridges
ridgier937882ridgier
ridging104112982ridging
ridgy104110642ridg_y
rigid7913892ri_gid
sigil63515502si_gil
vigil94313002vi_gil
aidful1057073aidful
argil65116883_argil
bidi78226593bid_i_
bidis86721143bid_is
biggie103810933biggie
biggin103710603biggin
bridal9511453brid_al
bridge103711883bridg_e
bridged12339033bridged
bridges113911333bridges
bridging13288443bridging
budgie104310343budgie
civil103411933ci_vil
cudgel1036703cudgel
deil56231623__deil
didie74120563did_ie
digit73825273di_git
dingily1238103dingily
distil73616433distil
edgily1136063_edgily
fibril1137163fibril
fidge104516063fidg_e
fidged124610933fidged
fidges114114393fidges
fidget114216483fidget
fidging133910503fidging
fizgig2032973fizgig
fodgel1136413fodgel
fridge11379253fridg_e
fridges12369483fridges
frigid1136923fri_gid
giddily1335073giddily
gingal81010153gingal
gingili9306033gingili
ideal65716393_ideal
idol56818633_id_ol
idyl85912303_id_yl
idyll9436713_idyll
iridic9328743irid_ic
jingal1498593jingal
kiddie12359393kiddie
kidvid1535023kidvid
midair937993midair
midge95016553midg_e
midges103516483midges
midget103718453midget
midgut103510053midgut
midi75628483mid_i_
midis85923413mid_is
midrib1138243midrib
nidal65217103nid_al
nidget83715643nidget
nidi56524403nid_i_
nihil8410283ni_hil
nitril62511533nitril
oidia6314953oid_ia
origin7311033ori_gin
pidgins11259123pidgins
piggie103210773piggie
piggin103111093piggin
pistil83915073pistil
podgily1435213podgily
pudgily1434903pudgily
radial74020393radial
radii64016413rad_ii
radio64922493rad_io
radix134414603rad_ix
ragi56032283r_agi_
ragis66325603r_agis
rail46147763r__ail
ramtil8311023ramtil
reagin74915533reagin
reboil83814683reboil
recoil84016723recoil
redfin10310223redfin
redia65524483red_ia
redial74923113redial
redid74922393red_id
redip87816963red_ip
redrill857893redrill
redtail858713redtail
regal65023793r_egal
regild8149773r_egild
regilt71217493r_egilt
remail85017123remail
renail65020763renail
reoil55321183r_eoil
resail64418733resail
retail65522073retail
rial45938093ri__al
ricin74620213ri_cin
rictal83113183rictal
rid46754633rid___
ridable101412493ridable
ridded93615123ridded
ridden83511723ridden
ridder84015143ridder
ridding103314193ridding
riddle83915713riddle
ride55945133rid__e
rident7520193rident
rider65231303rid_er
riders74123903riders
rides66140813rid_es
ridgiest1038903ridgiest
ridgling11258203ridgling
riding84325963riding
ridley10169543ridley
rids56539553rid__s
riel46432383ri__el
riflip1134723riflip
rig46748123ri_g__
rigged94517403rigged
rigger85616713rigger
rigging103016333rigging
right94430503ri_ght
rigidly1235533ri_gidly
rigor62714053ri_gor
rigs55137593ri_g_s
rill45140903ri__ll
ring56541153ring__
ringed84623843ringed
ringer74526063ringer
ringgit946013ringgit
ringing93521283ringing
rings65029173ring_s
ringtail944723ringtail
rishi8311253rishi_
rishis9312453rishis
riskily1436413riskily
ritual6310623ritual
ritzily1945143ritzily
rival85216503ri_val
riyal84413433ri_yal
roil46235293r__oil
ruddily1236303ruddily
rugal65916093r_ugal
sigils73912363si_gils
smidgin11335103smidgin
strigil837263stri_gil
tidal64516443tid_al
tidbit938493tidbit
tidily102811393tid_ily
vigia94813273vi_gia
vigils104210193vi_gils
virgin1038083virgin
wedgie11428373wedgie
widdie113410733widdie
widget113815263widget

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 Limit1127161635.37320978.2
3Display Results1631630.0632587.3
 (SQL Overall)1786911635.81230745.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.