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

128 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
geminates1231004(None) 
geminate11411811geminate_
geminated1338551geminated
germinates1347761germinates
deaminates1349382deaminates
dominates12311742dominates
emanates10311332_emanates
emirates101214852_emirates
gemmates13307672gem_mates
germinate1248632germinate_
germinated1446562germinated
laminates112712902laminates
nominates11311052nominates
resinates9314762resinates
ruminates11410192ruminates
terminates12410002terminates
abominates1446513abominates
acuminates1446883acuminates
agemates111110023agem__ates
agminate1139243agminate_
alginates10310123alginates
aluminates1248363aluminates
amirates101114793_amirates
bemingles1444743bemingles
bombinates16105013bombinates
brominates1448013brominates
celibates1358633celibates
criminates1448003criminates
culminates1447053culminates
deaminases1345283deaminases
deaminate12410173deaminate_
deaminated1448013deaminated
decimates14410693decimates
dedicates13311693dedicates
delaminates1456903delaminates
delicates12314313delicates
delineates1147123delineates
denominates14167203denominates
depilates12310923depilates
derivates13310093derivates
designates1246363designates
detonates10310433detonates
deviates12312733devi_ates
dominate11312853dominate_
dominated1339883dominated
effeminates1952603effeminates
eliminates1246973eliminates
emanate9312473_emanate_
emanated1139163_emanated
emendates1246083_emendates
emigrates1248583_emigrates
emirate91015833_emirate_
emulates10312573_emulates
enates64026433_e__nates
epilates10313503_epilates
feminacies1745383feminacies
feminazis2343153feminazis
feminines14218173feminines
feminises14229753feminises
feminities1549683feminities
feminizes23238523feminizes
festinates1348943festinates
fulminates1545883fulminates
fumigates1545573fumigates
gamines103618463gamin__es
gelates83219593ge__lates
gelignites1243583gelignites
geminal10109913gemina__l
geminally1576403geminally
geminating1447763geminating
gemination131410663gemination
geminations14139263geminations
gemmate12418383gem_mate_
gemmated14336293gem_mated
gemotes103712143gem__otes
generates10312713generates
gentes75324163ge__n_tes
gestates93213733ge_states
herniates1247333herniates
hesitates1269793hesitates
imitates10310503_imitates
inseminates1345893inseminates
iodinates1048203iodinates
laminate103014633laminate_
laminated122610283laminated
lemonades1244093lemonades
levigates1346493levigates
levirates1247493levirates
levitates1247863levitates
marinates112516383marinates
mediates112814063medi_ates
medicates14312113medicates
meditates1239813meditates
melinites11310413melinites
minutes93513443__minutes
neonates8310063ne_onates
nominate10312473nominate_
nominated1239283nominated
ordinates1049003ordinates
paginates123111363paginates
patinates113814693patinates
penates93321603pe__nates
pepsinates1446373pepsinates
remates93827113rem__ates
remigrates1348583remigrates
reminted113615083remin_ted
remints95117293remin_t_s
renominates13137803renominates
resinate8316773resinate_
resinated10413283resinated
resonates9412403resonates
retinites9313503retinites
ruinates8311883_ruinates
ruminate10511473ruminate_
ruminated1258663ruminated
selenates91611363selenates
seminaries12410003seminaries
seminars1079053semina_rs
senates73322613se__nates
seriates82620673seri_ates
supinates1139553supinates
templates1348273templates
terminate11411203terminate_
terminated1348163terminated
urinates8314133_urinates
venenates1247583venenates
veritates12310973veritates
vesicates14119033vesicates

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411286.84621712.1
3Display Results1281280.0602133.3
 (SQL Overall)1786911287.35924282.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.