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

174 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
girns6451680(None) 
airns55521031airns
firns86018541firns
gins55543951gi_ns
girds74816991girds
girls64518391girls
girn56026861girn_
girons75014371girons
giros65722651giros
girts65423621girts
grins65427221grins
kirns95315451kirns
pirns76020091pirns
ains46158882ai_ns
airn46433832airn_
airs46447422air_s
airts55626342airts
bairns86710872bairns
barns76335142barns
bins66548242bi_ns
birds85421332birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
brins75533972brins
burns74926772burns
cairns85313302cairns
carns75937562carns
cions75222852cions
cires74932912cires
corns76034762corns
curns74924272curns
darns66927892darns
dins56652042di_ns
dirks105619522dirks
dirls64720502dirls
dirts66824462dirts
durns64819862durns
earns55927562earns
erns45428222_erns
ferns85220082ferns
fins75849092fi_ns
fires85740752fires
firms105217422firms
firn76927502firn_
firs76637712fir_s
gains65729512gains
garbs86321412garbs
garni6315702garni
gars55750742gar_s
gens55740072g_ens
germs85118872germs
giant65430592giant
giants74713502giants
gibes84422522gibes
gibs75529262gi_bs
gids65933732gi_ds
gien56330022gien_
gies55641422gi_es
gifts96214962gifts
gigas75415582gigas
gigs66631182gi_gs
gilds75417522gilds
gills64728192gills
gilts64924262gilts
gimps105915202gimps
gin46055752gi_n_
gink97129522gi_nk
ginks104319562ginks
ginny95314572ginny
gipons9389602gipons
gips75632922gi_ps
gird65424992gir_d
girl56226552gir_l
girly94415292girly
girned84010512girned
giro55828632gir_o
giron66118992giron
girsh95310022girsh
girt56646422gir_t
girth95618842girth
girths105612272girths
gists66026192gists
gites65630182gites
gits55744592gi_ts
givens10379732givens
gives95324872gives
glans65125832glans
glens66519852glens
goons65326772goons
gores65740372gores
gorms85619592gorms
gorps85316992gorps
gowns95115102gowns
grans64832542grans
grids75321392grids
grigs75318192grigs
grin55733722grin_
grind75917562grind
grinds84511842grinds
grips85520132grips
grits65529582grits
guans64419442guans
guiros7389092guiros
guns55533482g_uns
gurus64318192gurus
gyres94820322gyres
gyrons105511222gyrons
gyros95616482gyros
gyrus95310802gyrus
herns84825582herns
hins76447992hi_ns
hires86134342hires
horns86125332horns
inns46920932_inns
ins35945602_i_ns
ions46737852_ions
ires45639282_ires
iris45732542_iris
irks86220132_irks
irons55324132_irons
jinns126013842jinns
jins115635012ji_ns
karns96624142karns
kerns94719562kerns
kilns95112982kilns
kins85747902ki_ns
kirks84915262kirks
kirn87123432kirn_
kirs85831732kir_s
liens56525502liens
limns75718392limns
linns56123332linns
lins47059052li_ns
lions55923212lions
liras56021982liras
miens76118302miens
mires75640882mires
mirins83918892mirins
mirks115122142mirks
mirs66940562mir_s
morns75527442morns
pians75126962pians
pins65558452pi_ns
pions75826392pions
pirn67128372pirn_
porns75527342porns
rins46153192ri_ns
signs65516322signs
sins46755272si_ns
sirens65318152sirens
sires55945372sires
sirs44338332sir_s
sorns55028412sorns
tarns56433952tarns
terns55226872terns
tins45251302ti_ns
tires55437492tires
tirls54519802tirls
tiros54524892tiros
turns55623232turns
urns46323892_urns
vires84529682vires
virls85618602virls
virus85316842virus
warns87231002warns
wins75949172wi_ns
wires86034912wires
yarns85621792yarns
yins75335122yi_ns
yirds96612512yirds
yirrs8469192yirrs
zins135735002zi_ns

Search took 9 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 Filter178691538000.546327272.9
2DLD Change Limit538001746.6568082.9
3Display Results1741740.0931871.0
 (SQL Overall)1786911747.29524495.0
 
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.