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

158 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
colouring125873(None) 
clouring112811271c_louring
coloring11414841colo_ring
closuring1255172closuring
cloturing1245472cloturing
clouding12269492c_louding
clouting113011682c_louting
cohousing1535282cohousing
collaring12310562collaring
colluding1335902colluding
colorings1247682colo_rings
conjuring1937912conjuring
contouring1347012contouring
culturing1236552culturing
decolouring1583432decolouring
flouring123010142_flouring
honouring1336882honouring
louring83916502__louring
alluring939073_alluring
armouring1244983armouring
blousing1138793_blousing
callousing1344273callousing
callusing1236173callusing
calquing2035593calqu_ing
capturing1436623capturing
carousing1237893carousing
cellaring1238533cellaring
censuring1237603censuring
chlorin123113003chlo_rin_
chlorine133013303chlo_rine
chlorins132612883chlo_rins
choiring14279793c_hoiring
choring133617663c_ho_ring
chousing14259423c_housing
clamouring15104773clamouring
clearing113014883c_learing
cloaking15299713c_loaking
clocking174312413c_locking
clogging13368503c_logging
clomping15329653c_lomping
cloning103215473c_lo_ning
clonking153810153c_lonking
clopping153511083c_lopping
closing103114843c_lo_sing
clothing14278783c_lothing
clotting113110643c_lotting
clowning14307253c_lowning
cloying133511753c_lo_ying
clueing104110093c_l_ueing
cluing93913503c_l_u_ing
cockering1839693cockering
cocooning1447023cocooning
coculturing1653213coculturing
coenduring1444233coenduring
coffering1838043coffering
cofounding1743673cofounding
cohering142413833co_hering
cohosting1546323cohosting
cohousings1642123cohousings
coiffuring1942573coiffuring
coinsuring1345373coinsuring
cojoining1945753cojoining
coleading1338523coleading
collaging1337933collaging
collating12312783collating
colleting12311063colleting
colliding1338583colliding
colloguing1444553colloguing
collying14319553col_lying
colocating1548623colocating
colonising1347643colonising
colonizing2248813colonizing
colorant10414723colo_rant
colorism122112433colo_rism
colorist102818993colo_rist
colorize192314203colo_rize
colorizing2249633colorizing
colour85915093colour___
coloured1148313colour_ed
colourer1037563colour_er
colourers1136473colourers
colours95913443colour__s
colubrine1345043colubrine
communing16207863communing
commuting16288443commuting
comparing162410583comparing
compering163414163compering
computing16309853computing
concurring1546603concurring
conducing1537693conducing
confusing1537333confusing
confuting1539093confuting
conquering2246273conquering
consuming1437913consuming
contusing1239143contusing
cooeeing1137453co_oeeing
cooeying1438143co_oeying
cooing94024923co_o__ing
cooking143818973co_o_king
cooling103422573co_o_ling
coopering142611323coopering
cooping123918933co_o_ping
coopting133411313co_opting
coplotting1555953coplotting
coppering162810893coppering
coring94433963c__o_ring
cornering12311893cornering
coshering15510023coshering
costuming1445283costuming
couping124317023c__ouping
coursing113112023c__oursing
courting112514573c__ourting
covering142215723co_vering
cowering142514033co_wering
curing94824783c___uring
decoloring1486313decolo_ring
delousing1136303delousing
detouring1136973detouring
devouring1435953devouring
discolouring1652643discolouring
favouring1644023favouring
flooring12259883_flooring
flouting122610473_flouting
glouting10379693_glouting
hollering1337743hollering
holocrine1495343holocrine
honoring12310473hono_ring
humouring1544553humouring
inpouring1236393inpouring
labouring1236213labouring
louping104313983__louping
lousing83817733__lousing
louting83719383__louting
luring73820753__l_uring
moldering1367863moldering
mooring102514443mo_o_ring
motoring11410953moto_ring
nonjuring1756053nonjuring
polluting1235703polluting
posturing1238993posturing
pouring103115863__pouring
recoloring1367583recolo_ring
repouring12310073repouring
rumouring1244513rumouring
savouring1335193savouring
scouring112810853_scouring
sojourning1841713sojourning
soldering1169033soldering
soloing82813803solo__ing
souring83219063__souring
sulfuring1345783sulfuring
tabouring1245723tabouring
tonsuring1046503tonsuring
torturing1036253torturing
touring82915193__touring
vapouring1544653vapouring
veluring1237563vel_uring
voluming1435043vol_uming

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.406440125.6
2DLD Change Limit1486411586.53322752.3
3Display Results1581580.0602633.3
 (SQL Overall)1786911586.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.