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 “germane” 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
germane104966(None) 
german9611981german_
germans1079471germans
ermine8416922_ermine
fermate122813002fermate
gemmae11507792gemma_e
gemmate12418382gemmate
germander1345362germander
germanely1543992germanely
germanic1367502germanic
germanize2148262germanize
germen9612312germen_
germens1078632germens
germina1038502germina
gormand1157452gormand
hermae115314472herma_e
merman10513862merman_
terrane72814232terrane
aerate64830553aer_ate
agemate101210583age_mate
airman82414223airman_
arcane81216743_arcane
barman103519713barman_
bedmate1239433bedmate
berake124216083ber_ake
berate84729023ber_ate
bereave1258353bereave
berline93716853berline
berme96022943berm__e
berming123614833berming
borane84620213bor_ane
carman103920753carman_
carmine112918483carmine
cerate84829463cer_ate
cervine122610803cervine
cetane8315283ce_tane
crane75331603_cr_ane
cremate113816183cremate
decane93818873de_cane
demand104314253de_mand
deplane10311413deplane
derange939813der_ange
derate74531233der_ate
derma84918513derma__
dermal93614343derma_l
dermas94116813derma_s
desman9311693desman_
desmans1039003desmans
dormant102814373dormant
erase54925493_er_ase
ergate7315143_ergate
ermined10410603_ermined
ermines9416673_ermines
erne46727433_er__ne
errand758793_errand
errant6618733_errant
ethane94613243_ethane
female11310553fe_male
feriae95618603feria_e
ferine96422583fer_ine
fermata12278143fermata
ferment12315573ferment
ferrate103014043ferrate
firman112211343firman_
firmans12238523firmans
formant123416003formant
formate123115093formate
furane94015493fur_ane
gagman103811243gagman_
gamine94620153g_amine
gane55145303g___ane
garage8314513gar_age
garbage1138053garbage
gardant9314463gardant
garganey1344883garganey
garland948703garland
garment10315233garment
gasman92911743gasman_
gearcase1154453gearcase
gelant72821673ge_lant
gelate73421263ge_late
gellant83214053gellant
gemma106311773gemma__
gemmated14336293gemmated
gemmates13307673gemmates
gemming13289153gemming
gemmule12173233gemmule
gemote94613023ge_mote
gene56237223ge___ne
genuine838373genuine
geomancer1443753geomancer
geomancy1644153geomancy
gerah9315303ger_a_h
gerahs1039413ger_ahs
gerent73223103ger_ent
germ75428963germ___
germanders1444603germanders
germanium1445023germanium
germanized2347133germanized
germanizes2248153germanizes
germfree1442683germfree
germier10309543germier
germinal1147263germinal
germinant1246183germinant
germinate1248633germinate
germiness1257693germiness
germlike1535093germlike
germs85118873germ__s
germy115113663germ__y
gerund836163ger_und
gestate83614073gestate
gleeman1035363gleeman_
gormands1266563gormands
gorming112810833gorming
gourmand1243263gourmand
grace85124543g_r_ace
grade75126093g_r_ade
gramme114210333g_ramme
gran56335013g_r_an_
grana65722093g_r_ana
grand75122693g_r_and
grange83716203g_r_ange
grans64832543g_r_ans
grant64840023g_r_ant
grape84824663g_r_ape
grate64932883g_r_ate
grave94624873g_r_ave
graze155820053g_r_aze
grease75416233g_rease
greave104611493g_reave
gremmie1264383gremmie
grenade938413grenade
grimace1255083grimace
groan65618423g_roan_
groaned9259973g_roaned
groaner82510133g_roaner
groans74815063g_roans
groyne1037213g_royne
gunman9299453gunman_
gyrase10508773gyr_ase
gyrate104912523gyr_ate
gyrene10227243gyr_ene
harmine122816193harmine
henbane1237363henbane
heptane1238363heptane
herbage1337013herbage
herdman13238423herdman_
herma105318883herma__
hermai118912863herma_i
heroine103517493heroine
hetman112510603hetman_
hetmans12187593hetmans
hexane16379533he_xane
hogmane1336343hogmane
hormone12410503hormone
humane112812173_humane
immane1038883_immane
kerne94718223ker__ne
legman949653legman_
leman75622603le_man_
lemans85316393le_mans
lurdane835983lurdane
mane65052033___mane
mermaid1297853mermaid
mermen10813813mermen_
methane123211793methane
nervate1039533nervate
nervine102510633nervine
normande1145943normande
overman12311463overman_
overmans13310313overmans
overmany1647143overmany
overmine13313663overmine
penman10312323penman_
pentane9415743pentane
percale11314093percale
permanent1368783permanent
permeance1545913permeance
permeant12310913permeant
permease1246503permease
permeate12311613permeate
permian112612283permian_
perming123416093perming
permute1138793permute
pervade1337023pervade
premade12311443premade
preman104117453preman_
premune1138933premune
recane83022873re_cane
reimage1037913reimage
remade94316983re_made
remake124016113re_make
reman75730153re_man_
remand95618963re_mand
remans84823003re_mans
remate84428683re_mate
reran57329103rer_an_
seaman84015903seaman_
serape84818413ser_ape
serene63522353ser_ene
serfage1138403serfage
seriate73722473seriate
serine65432673ser_ine
sermon8413553sermon_
sermons9311783sermons
serrano768463serrano
serrate73017543serrate
servant10313633servant
spermine12311433spermine
terming104016003terming
termini93410813termini
termite9313893termite
ternate7415483ternate
terne56426153ter__ne
terpene92310863terpene
terrace93311843terrace
terrae62915213terra_e
terranes82514433terranes
terrene72411033terrene
terrine72517573terrine
thermae125310503therma_e
urbane82211383_urbane
verdant11313293verdant
vermian12329713vermian_
vermin113414523vermin_
versant10313833versant
versine102515173versine
yeoman1138823yeoman_

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.436409841.7
2DLD Change Limit1340272286.96619240.2
3Display Results2282280.0962375.0
 (SQL Overall)1786912287.49823831.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.