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 “gaposis” 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
gaposis103842(None) 
apsis75718292_ap_sis
gaposises1245522gaposises
gnosis75711212g_nosis
haplosis1347092haplosis
abiosis939373abiosis
adiposis1146253adiposis
adonis7314063_adonis
agaroses938823agaroses
agnosia837643agnosia
agnosias947243agnosias
aiolis6316843_aiolis
alphosis1347273alphosis
aphesis12610513_aphesis
aphis105917133_ap_his
apoapsis1244103_apoapsis
apodosis1146583_apodosis
apods86316343_apo_ds
aporia8315863_aporia
aporias9315153_aporias
apos65433823_apo__s
apostil947903_apostil
apostils1046773_apostils
apposes11511473apposes
apses76823913_ap_ses
arsis55722423_a_rsis
basis75429863ba__sis
capons104119503capo_ns
capos94826073capo__s
capotes11314643capotes
capris10415083cap_ris
capsid11312413cap_sid
capsids1239333cap_sids
cassis84818853ca_ssis
cyanosis1346273cyanosis
dalasis8810533dalasis
deposes103117213deposes
deposit10313003deposit
deposits1138843deposits
diplosis11128413diplosis
enosis63816423_enosis
eposes84418783_eposes
exposes1639963exposes
exposit1649683exposit
exposits1747243exposits
gaboons10289903gaboons
gaddis94211373ga_ddis
gadis74825293ga__dis
gadoid9310463gado_id
gadoids1036873gadoids
galoots82410793galoots
galops94712623galo_ps
galores82614343galores
galosh1038573galos_h
galoshe1135413galoshe
galoshes1236913galoshes
ganofs104010293gano_fs
ganoid8314443gano_id
ganoids939333ganoids
gaols66717573ga_o_ls
gapers94520473gap_ers
gapes86030823gap__es
gapless10349993gapless
gaps76042973gap___s
garotes8614563garotes
gases65633993ga__ses
gasps85415483ga__sps
gasses75724783ga_sses
gasts66628633ga__sts
gateposts1243103gateposts
gators74115843gato_rs
gauss65613453ga_us_s
gausses8308693gausses
gavots1038113gavo_ts
gawsie1038463ga_wsie
gazoos163010223gazo_os
genesis82510823genesis
ghosts10489273g_hosts
gipons9389603gipo_ns
gipsies1039903gip_sies
gloss64319623g_los_s
glosts74513813g_losts
gnoses76515163g_noses
goalposts1252163goalposts
gomphosis1744453gomphosis
gooses75723053g_ooses
gross65421693g_ros_s
gummosis1343713gummosis
gypsies1335953gyp_sies
haploses1338853haploses
hypnosis1646533hypnosis
imposes113213683imposes
imposts11269003imposts
kapoks11347263kapo_ks
kaross101910013karos_s
kenosis11369003kenosis
ketosis11429733ketosis
kyphosis2045173kyphosis
lapis76223153lap__is
lapises93513463lapises
lapses85217693lap_ses
lapsus8437273lap_sus
lassis65216703la_ssis
meiosis939023meiosis
miosis83615163_miosis
mitosis939633mitosis
mycosis1437763mycosis
myosis114012563_myosis
narcosis10388043narcosis
oasis56422553oa__sis
opposes1149243opposes
osmosis976573osmosis
ostosis71310123ostosis
papisms13238543papisms
papists112110453papists
papooses1248053papooses
paresis93315093paresis
patois84319363pato_is
pois66539043__po_is
polis74731163__polis
poses74642763__poses
posies84431433__posies
posit75833333__posit
posits85718713__posits
posts75228783__posts
psis68120343__p_sis
ptosis83611823_ptosis
pyosis114012123_pyosis
pyrosis12411653pyrosis
raphis114014323rap_his
rapists92510753rapists
reposes94021263reposes
reposit9315863reposit
reposits10310453reposits
riposts9279403riposts
samosas939293samosas
saponin9310263saponin
saponins1039453saponins
sapors84118813sapo_rs
sapotas939613sapotas
sapotes9313943sapotes
sapours93610623sapours
saroses73619333saroses
satoris7317253satoris
sepsis83011293sep_sis
sorosis72611973sorosis
sycosis1238823sycosis
tapis75028863tap__is
tapises92914013tapises
tatsois748373tatsois
vamoses1239143vamoses
vaporise13209633vaporise
vaporish16246733vaporish
vapors113812693vapo_rs
vapours12277463vapours
virosis1039023virosis
wapitis1236473wapitis
whoosis1335453whoosis
whosis1237173_whosis
xerosis14249663xerosis
yapocks18354723yapocks
yapoks15346783yapo_ks
yapons114411773yapo_ns
zygosis20405953zygosis
zymosis21487493zymosis

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.54620474.6
3Display Results1651650.0632619.0
 (SQL Overall)1786911656.99925530.9
 
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.