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

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

131 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
whig11551642(None) 
whid115418871whid
whigs125612641whigs
whim126220521whim
whin105225691whin
whip125521841whip
whir105519281whir
whit104834171whit
whiz195919941whiz
wig76740381w_ig
ahi68040232ahi_
ahing98928342ahing
ahis76135382ahis
big67345712_big
brig76528032brig
chi86228652chi_
chia96026622chia
chic115925202chic
chid106626402chid
chin96934742chin
chip116726422chip
chis95933312chis
chit96937462chit
chug105914112chug
cig67036182_cig
dig57544472_dig
fig76242832_fig
frig85424502frig
ghi77019882ghi_
ghis85020162ghis
gig56040752_gig
grig65424772grig
hag77255742_hag
hi57947582_hi_
hic86540562_hic
hid76248362_hid
hie67652702_hie
high116619912_high
him86247652_him
hin67559562_hin
hip86750432_hip
his66359502_his
hit66569192_hit
hog78049062_hog
hug76037362_hug
jig115633512_jig
khi106318302khi_
khis117017982khis
mig65646072_mig
ohia75719362ohia
ohing96018802ohing
phi86524202phi_
phis95724902phis
phiz186718842phiz
pig65744972_pig
prig75924872prig
rig46748122_rig
shag86430562shag
shim95827842shim
shin75634302shin
ship95228232ship
shit76745932shit
shiv105721162shiv
shog86025132shog
swig85818022swig
thigh12410112thigh
thin76732382thin
thing96622962thing
thio77225412thio
thir76420542thir
this76027382this
thug86415482thug
trig55528162trig
twig87615772twig
vig75637522_vig
wag76451752w_ag
waif105836742waif
wail75238822wail
wain75840192wain
wair75830052wair
wait75553692wait
weigh125412512weigh
weir76019922weir
wha96422072wh_a
wham125321692wham
whang124813382whang
whap125119642whap
what105434072what
whee105429592whee
when105723042when
whet105133782whet
whew137618782whew
whey135018712whey
which163910082which
whids125413982whids
whiff17310052whiff
while115418692while
whims134515332whims
whine116022812whine
whinge134311532whinge
whins114922332whins
whiny144915572whiny
whips134917082whips
whipt135317422whipt
whirl114913822whirl
whirr114611192whirr
whirs115218092whirs
whish144512922whish
whisk154510142whisk
whist115322952whist
white114920302white
whits115923822whits
whity145513472whity
whizz194210322whizz
who95526772wh_o
whoa106615202whoa
whom127018172whom
whop125520922whop
whup125714162whup
why126920012wh_y
whys137011662whys
wigs84931252w_igs
win66456292w_in
wing86339222wing
wis66552332w_is
wit66563772w_it
wiz156434152w_iz
wog76242732w_og
wring95920712wring
writ75537912writ
zig136931902_zig

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 Filter178691298720.1401276364.3
2DLD Change Limit298721310.89333451.3
3Display Results1311310.0304366.7
 (SQL Overall)1786911311.063168100.7
 
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.