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

228 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
gitano73804(None) 
gitanos837171gitanos
agitato856572agitato
giant65430592gi_ant
guano69213982g_uano
litany939052litany
piano76118712pi_ano
pintano998992pintano
titan53318172titan_
titans63414912titans
witan83816502witan_
witans93412932witans
agita6315423agita__
agitas7310593agita_s
agitate8312063agitate
agitator946713agitator
beano75421553_beano
biting95321823biting
botany1139263botany
butane8313653butane
butanol945433butanol
catalo8314853catalo
cetane8315283cetane
chicano1496873chicano
ciao64924183ci_a_o
citator9310123citator
citing94220183citing
citron83112983citron
cotan71521783cotan_
cotans81317923cotans
cyano105512493_cyano
diazo15310033di_azo
dino56036753di__no
distant83519953distant
dita56032523dita__
ditas65923673dita_s
dittany1135653dittany
ditto65315603dit_to
divan96114843divan_
divans104612393divans
diwan95712553diwan_
diwans105110373diwans
extant132714753extant
fano75831693__fano
fino76034693fi__no
gaiting93716583gaiting
galago838913galago
gan48060133g__an_
gane55145303g__ane
gang66031983g__ang
ganof95420363g__anof
gating84826953gating
gazabo1834833gazabo
gelant72821673gelant
gelato73812963gelato
gestapo1044493gestapo
geta56627443geta__
getas65421483geta_s
giants74713503gi_ants
gibbon1135323gibbon
gibing103712353gibing
gibson935123gibson
gieing83614853gieing
gien56330023gi_en_
gifting123810893gifting
giga66720943giga__
gigas75415583giga_s
gigaton946343gigaton
gigolo836533gigolo
gin46055753gi__n_
gingko12376033gingko
gink97129523gi__nk
ginkgo12334943ginkgo
ginny95314573gi_nny
gins55543953gi__ns
ginzo1539613gi_nzo
gipon84212413gipon_
gipons9389603gipons
girasol874623girasol
girn56026863gi_rn_
girns64516803gi_rns
giro55828633gi__ro
giron66118993giron_
girons75014373girons
girting93113333girting
gismo848863gi_smo
git46266053git___
gite55438613git__e
gites65630183git_es
gits55744593git__s
gitted84015053gitted
gittin72910553gittin
gitting93215703gitting
given95915283given_
givens10379733givens
giving114313883giving
gizmo1756013gi_zmo
gland75217713g_land
glans65125833g_lans
glean65818203glean_
gleans75014743gleans
goban84414073goban_
gobang10376703gobang
gobans94412043gobans
gowan95415743gowan_
gowans105512293gowans
gowany13457493gowany
gran56335013g_ran_
grana65722093g_rana
grand75122693g_rand
grans64832543g_rans
grant64840023g_rant
groan65618423groan_
groans74815063groans
guaco85012163g_uaco
guan55325583g_uan_
guanos73811993g_uanos
guans64419443g_uans
guitar7117443guita_r
guitars8116863guitars
hitman112710223hitman_
iguana735813iguana
imago8118693_imago
imino74315233_imino
inane52820343_inane
jiao115017843ji_a_o
kiang104811353ki_ang
kimono12105413kimono
kino86233623ki__no
kiting114117093kiting
latino64120473latino
liana53915893li_ana
liane54720663li_ane
liang64914413li_ang
ligan67920283ligan_
ligand85011293ligand
ligans76817733ligans
liman75921603liman_
limans84816303limans
lino46343373li__no
litai55216363lita_i
litas54923773lita_s
litho86513783lit_ho
llano5910603_llano
mano66536813__mano
mikado1344513mikado
mutant8317693mutant
natant6318733natant
nitinol745143nitinol
niton55418283niton_
nitons64614903nitons
nitro54914353nit_ro
nutant6316383nutant
octan71313483octan_
octane81411633octane
octanol944743octanol
octans81411143octans
octant81216553octant
octavo11124783octavo
paisano9429513paisano
pian66136093pi_an_
pianos84315933pi_anos
pians75126963pi_ans
picaro10311323picaro
pinang92611593pinang
pintado1096573pintado
pintanos10107553pintanos
pirana8713263pirana
pita65436433pita__
pitas77427673pita_s
pitaya1186603pitaya
pitman102412123pitman_
pitmans11188743pitmans
piton76121583piton_
pitons85319043pitons
potato8513433potato
ratan53722663ratan_
ratans63819373ratans
ratany93411873ratany
riant55833153ri_ant
riband9239623riband
ritard74812083ritard
romano84912943romano
satang75711563satang
seitan62613233seitan_
seitans73312303seitans
silane62718053silane
sitar54820543sita_r
sitars65417593sitars
siting74126623siting
solano65314183solano
stand65923283_stand
stane55933003_stane
stang66424693_stang
stank95823303_stank
stanol6310723_stanol
steno54716863_steno
taco67031353__taco
tan37167583__tan_
tang56138693__tang
tango66921193__tango
tank85134033__tank
tans46154833__tans
tanto55724953__tanto
tao38358953__ta_o
taro46846913__taro
tetany959843tetany
timpano11235863timpano
tisane6311573tisane
titania738293titania
titanic968553titanic
titanous846553titanous
titian62512663titian_
titians72710453titians
titman82711003titman_
titrant7315193titrant
viand9511073vi_and
vino76128433vi__no
virago1046643virago
vita75828523vita__
vitae84217633vita_e
vital84819673vita_l
vitals94514303vitals
wigan95114393wigan_
wigans104511703wigans
wino75933613wi__no
witing103522823witing
zingano1744203zingano

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.376475242.0
2DLD Change Limit1127162285.04622337.7
3Display Results2282280.0763000.0
 (SQL Overall)1786912285.49832501.1
 
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.