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

161 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
gimmals1222582(None) 
gimbals12257821gimbals
gimmal11247511gimmal_
dismals102010242dismals
gammas115714692gamma_s
gimbal11228812gimbal_
gimels938892gi_mels
gimmes113010902gimm_es
gimmies123010112gimmies
gingals9109312gingals
gummas114810512gumma_s
hammals14409222hammals
mammals10389272mammals
timbals11239532timbals
airmails1045273airmails
animals94111703animals
bimahs13508303bi_mahs
bimas95521743bi_ma_s
bimetals1246943bimetals
biomass1155993biomass
bitmaps1344253bitmaps
bromals1139743bromals
bummalo1353793bummalo
bummalos1442873bummalos
citrals91111673citrals
commas124814573comma_s
cymbals16236143cymbals
dammars12308193dammars
dials64925343di__als
dimmable1536113dimmable
dimmers123811563dimmers
dismal92412243dismal_
dismays13237433dismays
finals94316163fi_nals
finials103210153finials
firmans12238523firmans
fiscals1238003fiscals
formals123312893formals
gals57946503g___als
gamas85431363g_ama_s
gamays126310913g_amays
gambas115817513gamba_s
gambols1238593gambols
gamma106116103gamma__
gammers123214563gammers
gammons1237973gammons
gavials1136603gavials
gayals1039513g_ayals
gemma106311773gemma__
gemmae11507793gemma_e
gemmate12418383gemmate
gemmates13307673gemmates
gemmily1534603gemmily
gemmule12173233gemmule
gemmules13183213gemmules
germans1079473germans
gigas75415583gi_ga_s
gills64728193gi__lls
gimbaled14104173gimbaled
gimel8313353gi_mel_
gimlets10338433gimlets
gimme102411343gimm__e
gimmick1843273gimmick
gimmicks1942473gimmicks
gimmie11298183gimm_ie
gimps105915203gi_m_ps
gingal81010153gingal_
gingall9117333gingall
gingalls1096433gingalls
girls64518393gi__rls
gismos957183gism_os
gizmos1844133gizm_os
glimmers13396153glimmers
gliomas1035333glioma_s
goals65521293g__oals
gomerals1147443gomerals
goorals838703goorals
gorals76917653g_orals
graals74112913g_raals
gramas94317203grama_s
grammars13345943grammars
grammas12499773gramma_s
gremials1136133gremials
gumball1266833gumball
gumballs1345313gumballs
gumma105313103gumma__
gummata1244613gummata
gummers123712203gummers
gummous1236263gummous
hamals114816823_hamals
hammal134512063hammal_
hammams13386443hammams
hiemal11339503hiemal_
hymnals1543523hymnals
ideals75012503_ideals
imams91511113_i_mams
imbalm1246323_imbalm
imbalms1334553_imbalms
immane1038883_immane
immies102412443_immies
impala10256933_impala
impalas11236953_impalas
impale102811663_impale
impales113311763_impales
impels10389523_impels
jimjams1742073jimjams
jimmies18328783jimmies
jingals1588073jingals
jumbals18106533jumbals
kismats13257843kismats
kummels15234793kummels
lemmas10349163lemma_s
limans84816303li_mans
limas75627633li_ma_s
limbas105313203limba_s
limmers113413083limmers
limpas105513083limpa_s
mammal95112753mammal_
mammas94616403mamma_s
meals75933373__meals
mimbars1397383mimbars
minimals12327433minimals
miskals13369763miskals
missals93914423missals
mommas94110653momma_s
normals92510903normals
pibals103813083pi_bals
pimas94725103pi_ma_s
pineals93212843pineals
pipals104213643pi_pals
pitmans11188743pitmans
pommels13235783pommels
pummels13236543pummels
rials55026673ri__als
rimmers113812883rimmers
rituals738353rituals
rivals94213183ri_vals
riyals94111083ri_yals
sambals115213483sambals
sials54227243si__als
sigmas94111363sigma_s
signals8359163signals
simars84916933si_mars
simas75727553si_ma_s
simians959203simians
simmers113314613simmers
simnels976103simnels
sisals63013573si_sals
summas104313163summa_s
tamals84116633_tamals
ticals83214713ti_cals
timbal102510753timbal_
timbale11248803timbale
timbales12227843timbales
tincals93610643tincals
tymbals14265723tymbals
vials85822383vi__als
vinals94716483vi_nals
visuals1036853visuals
vitals94514303vi_tals
wadmals1335513wadmals

Search took 7 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.1561145455.1
2DLD Change Limit1340271616.76619808.9
3Display Results1611610.0602683.3
 (SQL Overall)1786911616.98225593.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.