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

117 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
fizgig203297(None) 
fizgigs2142201fizgigs
fidging133910502fidging
figging133313562figging
fishgig1542102fishgig
fizzing19276402fizzing
biggie103810933biggie
biggin103710603biggin
bigging122815883bigging
bigwig1333343bigwig
bilging114212683bilging
binging113619383binging
digging113513703digging
digit73825273di_git
dinging103618613dinging
fadging134210243fadging
fagging133714763fagging
fagin9216573f_agin
fazing194418643fazing
fibbing15339463fibbing
fibril1137163fibril
fibrin1138533fibrin
ficin103516723fi_cin
fidge104516063fidg_e
fidged124610933fidged
fidges114114393fidges
fidget114216483fidget
fifing134212343fifing
fig76242833f___ig
figged124013893figged
fight124027093fi_ght
figs85332643fi_g_s
filing103823763filing
filling113520803filling
fillip11268953fillip
filmi105914003filmi_
filmic13348453filmic
filming133210353filming
filmis114610283filmis
finding124116543finding
finger104920333finger
fining104223213fining
finis86824263fi_nis
finking154016603finking
finning113615113finning
firing104021723firing
firkin1337823firkin
firming132811223firming
fishgigs1642093fishgigs
fishing143913863fishing
fistic11812573fistic
fisting113818123fisting
fitting113516563fitting
fixing174813783fixing
fixit154819303fi_xit
fiz156238763fiz___
fizz157519823fiz__z
fizzed18369443fizzed
fizzer17369383fizzer
fizzes174512553fizzes
fizzier18326713fizzier
fizzle17369713fizzle
fizzling20264993fizzling
fizzy199015083fiz_zy
flinging133310053flinging
fogging133513733fogging
fogie96719003f_ogie
forging124114723forging
frig85424503f__rig
frigging14268953frigging
frigid1136923frigid
fringing133010903fringing
frizing203310873frizing
frizzing2064803frizzing
fudging133310013fudging
fugging133912913fugging
fugio9310923f_ugio
fulgid1137043fulgid
fungi95014133fungi_
fungic12387813fungic
fuzil173810703fuz_il
fuzing194110643fuzing
fuzzing19336183fuzzing
gig56040753___gig
gigging93311773gigging
hinging123917123hinging
igg57116793_i_g_g
igging93212073_igging
jigging173011553jigging
kinging133115033kinging
migg85716803mi_g_g
pidgin10259813pidgin
piggie103210773piggie
piggin103111093piggin
pigging123614673pigging
pinging113419553pinging
ridgil8316823ridgil
ridging104112983ridging
rigging103016333rigging
rigid7913893ri_gid
ringing93521283ringing
sieging92613203sieging
sigil63515503si_gil
singing93221423singing
sizing163616443sizing
tinging93619463tinging
vigia94813273vi_gia
vigil94313003vi_gil
virgin1038083virgin
vizir17359393viz_ir
wigging133413833wigging
winging123718713winging
zig136931903__z_ig
zigging193210533zigging
zigzag1642963zigzag
zinging183513943zinging
zizit13313273ziz_it

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.390458182.1
2DLD Change Limit1127161175.39320900.4
3Display Results1171170.0303900.0
 (SQL Overall)1786911175.81330739.9
 
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.