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

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
friz16632434(None) 
fiz156238761f_iz
frig85424501frig
frit77044471frit
fritz176020771fritz
frizz165512621frizz
afrit8323172afrit
aria46245422aria
arid57642712arid
aril45843022aril
biz147939362_biz
brie65837902brie
brig76528032brig
brim85629372brim
brin67038192brin
brio65432492brio
bris65539612bris
brit66350152brit
crib86323582crib
cris66233432cris
crit65743712crit
drib76823262drib
drip76223952drip
fail74840242fail
fain75840562fain
fair76332522fair
feria85922712feria
fez156236822f_ez
fib86344272f_ib
fid76847692f_id
fie67152442f_ie
fig76242832f_ig
fil65447142f_il
fin66458032f_in
fir66744892f_ir
fire76245592fire
firm96026452firm
firn76927502firn
firs76637712firs
fit66365452f_it
fix136236102f_ix
fizz157519822fizz
flic96223732flic
flip96324262flip
flir76422202flir
flit76539272flit
foil76433912foil
foin77231562foin
frae75330472frae
frag85126272frag
frail85220212frail
frap95925812frap
frat75648542frat
fray105428902fray
free75940182free
fret75845042fret
friar85414272friar
fried95322912fried
frier85225842frier
fries85535602fries
frieze18378142frieze
frigs96019272frigs
frill84917562frill
frise85322452frise
frisk125312372frisk
frith115922032frith
frits86129102frits
fritt86129412fritt
frized193510682frized
frizer184011282frizer
frizes184015462frizes
frizzy20555832frizzy
fro65530642fr_o
froe75329992froe
frog85624362frog
from96923922from
frow106425052frow
froze174515652froze
frug86517102frug
fruit85122222fruit
fry96226502fr_y
futz167823802futz
fuzz158420572fuzz
grid65829612grid
grig65424772grig
grim76929422grim
grin55733722grin
grip76127022grip
grit55247242grit
irid55927172irid
iris45732552iris
kris86423602kris
phiz186718842phiz
prez156126312prez
prig75924872prig
prim85132202prim
prize164718942prize
quiz224920002quiz
ria36745502_ria
rib56848032_rib
rid46754632_rid
rif65951562_rif
rig46748122_rig
rim56052272_rim
rin36663182_rin
rip56851302_rip
ritz135129982_ritz
sri35634002sri_
sris45434152sris
trig55528162trig
trim65329522trim
trio45233342trio
trip66830392trip
uric63624942uric
whiz195919942whiz
wiz156434152_wiz
writ75537912writ

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.280638182.1
2DLD Change Limit298721170.89333451.3
3Display Results1171170.0139000.0
 (SQL Overall)1786911171.186150666.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.