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

165 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
gitanos83717(None) 
gitano738041gitano_
giants74713502gi_ants
guanos73811992g_uanos
pianos84315932pi_anos
pintanos10107552pintanos
titanous846552titanous
titans63414912titan_s
witans93412932witan_s
agitas7310593agita__s
agitates9310883agitates
agitato856573agitato_
agitator946713agitator
agitators1046623agitators
beanos85516513_beanos
bimanous1245693bimanous
butanes9312743butanes
butanol945433butanol
butanols1044713butanols
catalos9414163catalos
cetanes9315133cetanes
chicanos1595993chicanos
citator9310123citator
citators10310253citators
citrons92913223citrons
cotans81317923cotan_s
dinos65428063di__nos
ditas65923673dita__s
dittos74111973dit_tos
divans104612393divan_s
diwans105110373diwan_s
ethnos947053_ethnos
fanos85926503__fanos
finos86226953fi__nos
galagos938153galagos
gangs76222583g__angs
ganof95420363g__anof
ganofs104010293g__anofs
gatings95212823gatings
gazabos1944453gazabos
gelants82611443gelants
gelatos83111523gelatos
gestapos1153913gestapos
getas65421483geta__s
giant65430593gi_an_t
gibbons1234983gibbons
gibsons1045043gibsons
gigas75415583giga__s
gigaton946343gigaton
gigatons1046053gigatons
gigolos934693gigolos
gingkos13405343gingkos
ginkgos13314183ginkgos
ginks104319563gi__nks
gins55543953gi__n_s
gipons9389603gipon_s
girasol874623girasol
girasols984273girasols
girns64516803gi_rn_s
girons75014373giron_s
giros65722653gi__ros
gismos957183gi_smos
gites65630183git__es
gits55744593git___s
givens10379733given_s
gizmos1844133gi_zmos
glands85314403g_lands
glans65125833g_lan_s
gleans75014743glean_s
gobangs11385833gobangs
gobans94412043goban_s
gowans105512293gowan_s
grands84218243g_rands
grans64832543g_ran_s
grants73722473g_rants
groans74815063groan_s
guacos94410313g_uacos
guano69213983g_uano_
guans64419443g_uan_s
guitars8116863guita_rs
iguanas835383iguanas
imagos9117553_imagos
inanes62519803_inanes
kiangs11378363ki_angs
kimonos13114633kimonos
kinos96626143ki__nos
latinos73613803latinos
lianas63713383li_anas
lianes63819323li_anes
liangs74410593li_angs
ligands9438983ligands
ligans76817733ligan_s
limans84816303liman_s
linos55631503li__nos
litanies8310993litanies
litany939053litan_y
litas54923773lita__s
lithos94212553lit_hos
llanos6108333_llanos
manos74933623__manos
mikados1444683mikados
mutants938583mutants
nitinol745143nitinol
nitinols844413nitinols
nitons64614903niton_s
nitros64214123nit_ros
octanes91111393octanes
octanol944743octanol
octanols1044553octanols
octans81411143octan_s
octants9128733octants
octavos12134483octavos
paisanos10337553paisanos
petasos948603petasos
piano76118713pi_ano_
pians75126963pi_an_s
picaros11310893picaros
pinangs10267793pinangs
pintados11105993pintados
pintano998993pintano_
piranas9912613piranas
pitas77427673pita__s
pitayas1286263pitayas
pitmans11188743pitman_s
pitons85319043piton_s
ratans63819373ratan_s
ribands10208393ribands
ritards8439943ritards
romanos94311483romanos
satangs8479713satangs
seitans73312303seitan_s
silanes72517163silanes
sitars65417593sita_rs
solanos74412853solanos
stands75118053_stands
stanes64933403_stanes
stangs75018173_stangs
stanks104917703_stanks
stanol6310723_stanol
stanols739733_stanols
stenos63915773_stenos
tacos77023553__tacos
tangos74216323__tangos
tangs65028363__tangs
tanks94624743__tanks
tans46154833__tan_s
taos45541003__ta_os
taros55640823__taros
tetanus737933tetanus
tisanes7311853tisanes
titan53318173titan__
titaness836723titaness
titania738293titania
titanias847103titanias
titanic968553titanic
titanism1048213titanism
titians72710453titian_s
titrants838483titrants
viands1047813vi_ands
vinos84723073vi__nos
viragos1146713viragos
vitals94514303vita_ls
wigans104511703wigan_s
winos84625043wi__nos
witan83816503witan__

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.390458182.1
2DLD Change Limit1340271656.78019768.0
3Display Results1651650.0632619.0
 (SQL Overall)1786911657.23324705.0
 
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.