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 “causing” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

110 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
causing10361441(None) 
casing94829101ca_sing
pausing103912811pausing
abusing1049112abusing
accusing1336782accusing
amusing1039382amusing
auding83616932_auding
basing95427662ba_sing
bousing103718042bousing
busing96420592_busing
cabbing143613152cabbing
cabling124017552cabling
caching156317502caching
cadging123610972cadging
caging105321022ca_ging
caking134624672ca_king
calking144617782calking
calling103826772calling
callusing1236172callusing
calming123915972calming
calving134113502calving
camping143118972camping
campusing1654912campusing
caning94128622ca_ning
canning103620132canning
canting104725902canting
capping143819672capping
carding113922432carding
caring95137992ca_ring
carking144322852carking
carling103727062carling
carousing1237892carousing
carping123521082carping
carting104228282carting
carving133916772carving
cashing135022552cashing
casings104013512ca_sings
casini84615862ca_sini
casino84317552ca_sino
casking144317352casking
cassina94113162cassina
cassine93817282cassine
cassino93512432cassino
casting104628342casting
catling104819792catling
catting103922642catting
caucusing1443802caucusing
cauline92215602cauline
caulking1536802caulking
caving124822612ca_ving
cawing124322612ca_wing
ceasing104118262ceasing
censing104215262censing
cessing103814812cessing
chasing133715892chasing
chousing14259422chousing
chuting132910732chuting
classing113211792classing
closing103114842closing
clueing104110092clueing
cluing93913502clu_ing
couping124317022couping
coursing113112022coursing
cousin8517162cousin_
cousins9516002cousins
cruising112610152cruising
crushing143010052crushing
crusting113612792crusting
cubing114213952c_ubing
cueing94913612c_ueing
cuing85420192c_u_ing
curing94824782c_uring
cursing104217032cursing
cussing103814272cussing
daubing11358622daubing
dauting93814762dauting
dousing93315762dousing
easing74926462ea_sing
fusing104415952_fusing
gassing94216332gassing
gauging10339962gauging
gauming11319712gauming
hauling113714432hauling
housing113316522housing
jauking19418322jauking
jauping17307192jauping
lapsing103511162lapsing
lasing74727982la_sing
lauding93211902lauding
lousing83817732lousing
massing104318022massing
mauling103315682mauling
mousing103816272mousing
musing93919502_musing
parsing103819552parsing
passing104318422passing
raising83220532raising
rasing74330832ra_sing
reusing82516782reusing
rousing83920552rousing
sassing84615552sassing
saucing10311002saucing
sousing83517822sousing
tauting83316382tauting
tawsing1138672tawsing
tousing82916992tousing
using66317962__using
wauking153410012wauking
wauling112713112wauling
yauping13357242yauping

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711102.93636672.7
3Display Results1101100.0303666.7
 (SQL Overall)1786911103.34253468.3
 
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.