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

166 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
giros6572265(None) 
biros75325131biros
girds74816991girds
girls64518391girls
girns64516801girns
giro55828631giro_
giron66118991giron
girons75014371girons
girts65423621girts
guiros7389091guiros
gyros95616481gyros
tiros54524891tiros
aggros836552aggros
agios65919862agi_os
airns55521032airns
airs46447422air_s
airts55626342airts
bigos85020012bigos
bios66335322bi_os
birds85421332birds
birks114920302birks
birls74023162birls
biro66131212biro_
birrs74917102birrs
brios74725722brios
bros65635662_bros
ceros74726072ceros
chiros114617772chiros
cires74932912cires
didos76820812didos
dinos65428062dinos
dirks105619522dirks
dirls64720502dirls
dirts66824462dirts
duros65422692duros
eidos65817752eidos
eros45238452_eros
euros54920242euros
faros85532022faros
fidos95819052fidos
filos86125382filos
finos86226952finos
fires85740752fires
firms105217422firms
firns86018542firns
firs76637712fir_s
garbs86321412garbs
gars55750742gar_s
genros74211332genros
germs85118872germs
gibes84422522gibes
gibs75529272gi_bs
gids65933742gi_ds
gies55641422gi_es
gifts96214962gifts
gigas75415582gigas
gigot74023072gigot
gigots83911952gigots
gigs66631182gi_gs
gilds75417522gilds
gills64728192gills
gilts64924262gilts
gimps105915202gimps
ginks104319562ginks
gins55543952gi_ns
gipon84212412gipon
gipons9389602gipons
gips75632922gi_ps
gird65424992gir_d
girl56226552gir_l
girly94415292girly
girn56026862gir_n
girosol885302girosol
girsh95310022girsh
girt56646422gir_t
girth95618842girth
girths105612272girths
gismos957182gismos
gists66026192gists
gites65630182gites
gits55744592gi_ts
gives95324872gives
gizmos1844132gizmos
gobos86219382gobos
gogos77516522gogos
goos57644912g_oos
gores65740372gores
gorms85619592gorms
gorps85316992gorps
gos47155132g__os
grids75321392grids
grigs75318192grigs
grins65427222grins
griot65328412griot
griots74713642griots
grips85520132grips
grits65529582grits
grog65923342g_rog
grogs76319412g_rogs
grok95819682g_rok
groks105716122g_roks
gross65421692g_ross
grosz154814092g_rosz
grot55942052g_rot
grots65025852g_rots
grow86127302g_row
grows95523922g_rows
guiro63712092guiro_
gurus64318192gurus
gyres94820322gyres
gyro85217882gyro_
gyron95314622gyron
gyrons105511222gyrons
gyrose105310252gyrose
gyrus95310802gyrus
heros84930862heros
hires86134342hires
ires45639282_ires
iris45732552_iris
irks86220132_irks
iron46728462_iron
irons55324132_irons
kilos95021472kilos
kinos96626142kinos
kirks84915262kirks
kirns95315452kirns
kirs85831742kir_s
lidos65219882lidos
lilos55821872lilos
limos75320812limos
linos55631502linos
liras56021982liras
lirot5430032lirot
micros104115362micros
milos75428012milos
mires75640882mires
mirks115122142mirks
mirs66940572mir_s
misos76523292misos
nitros64214122nitros
pirns76020092pirns
pirog83913672pirog
pisos76021062pisos
pros65742782_pros
pyros105718292pyros
saros55238062saros
silos56029432silos
sires55945372sires
sirs44338332sir_s
taros55640822taros
tires55437492tires
tirls54519802tirls
tiro46832362tiro_
toros54336192toros
trios55528092trios
tyros85118592tyros
vinos84723072vinos
vireos94212452vireos
vires84529682vires
virls85618602virls
virus85316842virus
winos84625042winos
wires86034912wires
yirds96612512yirds
yirrs8469192yirrs
zeros144918112zeros

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 Filter178691538000.326548131.9
2DLD Change Limit538001661.53035163.4
3Display Results1661660.0503320.0
 (SQL Overall)1786911661.90693751.8
 
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.