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

162 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
signages103747(None) 
signage937771signage_
innages82911302_innages
linages8813172li_nages
signaled1035382signaled
signaler945442signaler
signalers1044572signalers
signals8359162signa_ls
signees83510802sign_ees
silages82514442si_lages
singes74326852si_n_ges
sinkages1386852sinkages
spinages11289292spinages
agnates82813183_agnates
alienages1045973alienages
apanages1137013apanages
baggages1335443baggages
binges93923123bi_n_ges
bisnagas1142843bisnagas
biznagas2041973biznagas
carnages11312213carnages
cognates11311573cognates
coinages11310803coinages
designates1246363designates
dinges83825423di_n_ges
dunnages10154933dunnages
engages92912493eng_ages
espionages1342423espionages
finagles12237553fi_nagles
finales104016013fi_nales
foggages1434213foggages
gages74529973__g_ages
hinges105121023hi_n_ges
ignites81310573_ignites
ignores8269003_ignores
images91411463_i_mages
inanes62519803_i_nanes
incages103013883_incages
ingates82716893_ingates
innage73011573_innage_
kinases113511123ki_nases
ligases82310703lig_ases
ligates82318373lig_ates
lignaloes1054023lignaloes
lignans8398853ligna_ns
lignites9129603lignites
linage7713403li_nage_
lineages979183lineages
linkages1385953linkages
luggages1143633luggages
magnates11511603magnates
manages103418963_manages
menages103615393_menages
migrates111112843migrates
milages103114403mi_lages
mileages11249693mileages
millages113212893millages
mintages111110513mintages
mirages102213533mi_rages
misnames12119883misnames
mispages13311183mispages
nonages8313843_nonages
pawnages1435313pawnages
peonages1138473peonages
pillages113012603pillages
pinnaces12268863pinnaces
pipages1289423pi_pages
pipeages1336423pipeages
rivages1138873ri_vages
sages65339063s___ages
salvages1238123salvages
sausages937003sausages
savages1139973s_avages
scalages113010253scalages
scutages1136503scutages
seepages1137283seepages
seignorages1351573seignorages
selvages1236513selvages
senates73322583s_enates
septages1168263septages
serfages1238233serfages
sewages1139753s_ewages
sieges73816833si__eges
sienites8311913sienites
siganids1045303siganids
sigmas94111353sigma__s
sigmate10710123sigmate_
signa66114703signa___
signal73711483signa__l
signalise1046393signalise
signalises1145913signalises
signalizes2046463signalizes
signalled1143833signalled
signaller1043693signaller
signallers1142833signallers
signally1246523signally
signalmen1252443signalmen
signatures1153513signatures
signed83413753sign__ed
signee73617233sign__ee
signer74015633sign__er
signers84714433sign_ers
signet73621153sign__et
signeted1035973signeted
signets83311503sign_ets
signifies1347063signifies
signiors944913signiors
signoras9306533signoras
signore8329093signore_
signories10107853signories
signors83410903sign_ors
signs65516323sign___s
silage72715303si_lage_
silanes72517163si_lanes
sines55954823si_n__es
singe65731133si_n_ge_
singed85422293si_n_ged
singer74227313si_n_ger
singers83824703si_n_gers
singles83520433si_ngles
sings65532703si_n_g_s
sinkage1287263sinkage_
sinuates8310953sinuates
sinuses73011593si_nuses
siphonages1642983siphonages
situates8310363situates
slippages1483983slippages
snags64421313s__nag_s
snakes103919603s__nakes
snares65329033s__nares
soakages1336143soakages
socages101012053s_ocages
soccages1336383soccages
soilages9189673soilages
spillages1256073spillages
spinage10289653spinage_
sponges10311043spon_ges
stages75629493s__tages
stagnates1046733stagnates
storages9311103storages
stowages1236473stowages
stranges94516763stranges
sullages939973sullages
surnames1037273surnames
swages104417073s__wages
swinges113413423swin_ges
syngases1245073syngases
tannages9228963tannages
thanages12107603thanages
thenages12107473thenages
tillages93011243tillages
tinges74722323ti_n_ges
tonnages9187873tonnages
tunnages9195903tunnages
vicinages1544073vicinages
villages123010593villages
vintages12118273vintages
visages1138693vi_sages
wagonages1443303wagonages
wigwags1543293wigwag_s
windages1338263windages
zigzags1742273zigzag_s

Search took 9 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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621628.67316852.5
3Display Results1621620.0602700.0
 (SQL Overall)1786911628.90620064.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.