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

296 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
gringos93667(None) 
eringos836911eringos
gringas938041gringas
gringo838641gringo_
bingos95514792_bingos
brings94618432bring_s
cringes103215502cringes
drongos935492drongos
eringo739552eringo_
eringoes937432eringoes
eryngos1142732eryngos
fringes113514102fringes
gingkos13405342g_ingkos
ginkgos13314182g_inkgos
goings84911522going_s
granges93516522granges
gregos847532gr_egos
grigs75318192gri_g_s
grinds84511842grin_ds
gringa838552gring_a
grins65427222grin__s
grunges93310402grunges
olingos846012olingos
pingos95317672_pingos
rings65029172_ring_s
stingos8459452stingos
trigos74214172tri_gos
wrings104012972wring_s
ageings9437693ageing_s
agings86312673aging_s
airings83913843airing_s
amigos94511213ami_gos
ariosos7409853ariosos
aristos7312373aristos
armings103811503arming_s
beings94613033being_s
bigos85020013_bi_gos
binges93923123_binges
bingo86020093_bingo_
bingoes104013983_bingoes
boings96416873boing_s
bongos95316653_bongos
borings103614243boring_s
bridges113911333bridges
brigs85823223bri_g_s
brillos9369183brillos
briners94315633briners
brines85028853brin_es
bring85528503bring__
bringer104213353bringer
bringers112811073bringers
brinies93317913brinies
brinks124616313brin_ks
brins75533973brin__s
brios74725723bri__os
broncos11188073broncos
chinos115018693chin_os
clings95716213cling_s
congos94219883_congos
cringe93515483cring_e
cringed113312403cringed
cringer103514243cringer
cringers112511873cringers
cringle103010353cringle
cringles11329463cringles
crinums1135863crinums
darings93713653daring_s
dinges83825423_dinges
dingo74720793_dingo_
dingoes94114833_dingoes
dings76331403_ding_s
dingus83611843_dingus
dinos65428063_din_os
doings84913183doing_s
drinks116810713drin_ks
drongo836793drongo_
dyings11478133dying_s
earings84517713earing_s
epinaos936283epinaos
erugos7347343er_ugos
eryngo1033613eryngo_
eryngoes1242943eryngoes
finos86226953_fin_os
firings114112333firing_s
flings106715283fling_s
fridges12369483fridges
friges104116483fri_ges
frigs96019273fri_g_s
fringe104013953fring_e
fringed123611523fringed
fringy13309263fring_y
gainers84214593gainers
gains65729513gain__s
galagos938153galagos
gamings114610913gaming_s
gangs76222583g_ang_s
gatings95212823gating_s
gearings10359503gearing_s
genros74211333g_enros
gigas75415583g_i_gas
gigot74023073g_i_got
gigots83911953g_i_gots
gigs66631183g_i_g_s
gingal81010153g_ingal
gingals9109313g_ingals
ginger84920033g_inger
gingers94118643g_ingers
gingko12376033g_ingko
gingkoes14404733g_ingkoes
ginkgo12334943g_inkgo_
ginkgoes14323743g_inkgoes
ginks104319563g_in_ks
gins55543953g_in__s
ginzo1539613g_inzo_
ginzoes1735433g_inzoes
girns64516803girn__s
giros65722653g_i_ros
gismos957183g_ismos
gizmos1844133g_izmos
glints75714213glin_ts
gogos77516523g__ogos
going75218493going__
gongs74921613g_ong_s
goriness9310753goriness
goring84119573goring__
grainers93012073grainers
grains74223093grain__s
grands84218243gran_ds
grange83716203grang_e
granger93514213granger
grangers103011973grangers
grans64832543gran__s
grantor84010943grantor
grantors93810363grantors
grants73722473gran_ts
gratings103910763grating_s
grazings19337263grazing_s
grego7310523gr_ego_
greiges937733greiges
grides84422363gri_des
grids75321393gri__ds
griefs10418723gri_efs
grieves1137323grieves
grievous1243583grievous
griffes14367923griffes
griffon1443103griffon
griffons1542573griffons
griffs13398993gri_ffs
grifts104511683gri_fts
grig65424773gri_g__
grigri833853gri_gri
grigris934093grigris
grilles83715023grilles
grills74314803gri_lls
grilses8319153grilses
grimes94619033gri_mes
grimness1175993grimness
grin55733723grin___
grinch1238483grin_ch
grinches1436953grinches
grind75917563grin__d
grinded104210633grinded
grinder93312393grinder
grinders103410423grinders
grinned9378553grinned
grinner8329233grinner
grinners9288043grinners
griot65328413gri__ot
griots74713643gri_ots
gripers104011463gripers
gripes94619873gri_pes
grippes124810373grippes
grips85520133gri__ps
griseous945613griseous
grison7310103gri_son
grisons838993grisons
grists74716483gri_sts
griths105211653gri_ths
grits65529583gri__ts
grivets11357973grivets
grogs76319413gr_og_s
groins73917203groin__s
grottos8337333grottos
grudges10349423grudges
grunge8359583grung_e
grunger9389783grunger
grungers10298503grungers
grungy11345973grung_y
grunion835433grunion
grunions945353grunions
grunts75511853grun_ts
guanos73811993guan_os
guineas836753guineas
guiros7389093gui_ros
gyring113910363gyring__
hinges105121033_hinges
icings9428453icing_s
infos84311673__infos
ingot61221063__ingot
ingots7912063__ingots
iring66025423iring__
jingo134615213_jingo_
jingoes153811443_jingoes
kings105825563_king_s
kinos96626143_kin_os
lingas75116573_lingas
lingo66022113_lingo_
lingoes84014693_lingoes
lings67135773_ling_s
linos55631503_lin_os
lyings10488503lying_s
mangos94319343_mangos
merinos9311983merin_os
mongos94318623_mongos
mungos94311373_mungos
olingo736933olingo_
oranges84215333oranges
orangs74116033orang_s
parings104219213paring_s
pengos94612413_pengos
pingo87122713_pingo_
pingoes105116523_pingoes
pings85830883_ping_s
pinkos125313873_pinkos
pintos86021293_pintos
prangs94816233prang_s
prigs85219703pri_g_s
primos104514423pri_mos
princes113015143princes
princox1843573princox
prinks124315383prin_ks
prints84320103prin_ts
prongs94314483prong_s
quangos1734653quangos
ranges73826933_ranges
rhinos94411123rhin_os
ridges85817013_ridges
rigor62714053_ri_gor
rigors72813713_ri_gors
rigs55137593_ri_g_s
rinds64826143_rin_ds
ring56541153_ring__
ringed84623843_ringed
ringer74526063_ringer
ringers83922953_ringers
ringtoss944203_ringtoss
rinks94827103_rin_ks
rins46153193_rin__s
rinses64720383_rinses
rondos74616733_rondos
rungs611819403_rung_s
seringas9339003seringas
singes74326853_singes
sings65532703_sing_s
slings74618013sling_s
sorings83817253soring_s
spintos939133spintos
springes114014033springes
springs104415923spring_s
stingo74212163stingo_
stings76220183sting_s
strings84617133string_s
swinges113413423swinges
swings104714453swing_s
syringas12285953syringas
syringes122810213syringes
tangos74216323_tangos
things104914303thing_s
tinges74722343_tinges
tings65329213_ting_s
triages82613793triages
trigo65716053tri_go_
trigon74513103tri_gon
trigons84312093tri_gons
trigs65423063tri_g_s
trines64132563trin_es
trios55528093tri__os
tripos84014923tri_pos
twinges11409453twinges
urinals7610263urinals
urines64724123urin_es
urinose738483urin_ose
urinous7310083urinous
vinos84723073_vin_os
viragos1146713viragos
whinges143610633whinges
wings95727243_wing_s
winos84625043_win_os
wirings113910113wiring_s
wrangs104611913wrang_s
wring95920713wring__
wringed123710193wringed
wringer113612453wringer
wringers123110073wringers
wrongs10338933wrong_s
zings154620893_zing_s

Search took 8 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 Filter1786911340270.403443402.0
2DLD Change Limit1340272966.92319359.7
3Display Results2962960.1102690.9
 (SQL Overall)1786912967.43624030.5
 
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.