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

159 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
situating103888(None) 
sinuating1039681sinuating
actuating1239232actuating
liquating1946312liquating
nitrating10312672nitrating
resituating1247542resituating
satiating10311812satiating
saturating11119202saturating
simulating1347612simulating
sitting83519632sit__ting
situation949422situation
situations1038432situations
stating83725162s_t_ating
stunting92811502s_tunting
titrating10310112titrating
vitiating1338412vitiating
agitating1138863agit_ating
bitting103717293bit__ting
dictating1338883dictating
dilating102714913di_lating
diluting10248983dilu_ting
disrating11714553disrating
equating18310113_equating
estating92614993est_ating
estimating1348883estimating
estivating1447633estivating
extubating2044423extubating
filiating1339253filiating
filtrating1445973filtrating
fitting113516563fit__ting
fixating1936183fi_xating
gitting93215703git__ting
habituating1743233habituating
hesitating1448003hesit_ating
hitting113017273hit__ting
ideating10311703_ideating
imitating1238763imit_ating
initiating1149623initiating
insinuating1244533insinuating
intubating1376713intubating
intuiting1089613intuiting
iodating1038823_iodating
isolating1039743isolating
iterating10314253_iterating
kitting123214443kit__ting
librating1239053librating
ligating102212283li_gating
litigating1246743litigating
maturating13108573maturating
micturating1644883micturating
migrating13910533migrating
minuting1139723minu_ting
misdating131010663misdating
miseating121215433miseating
mismating141211823mismating
misrating121014853misrating
mitigating1447433mitigating
mutating112211753mut_ating
nictating1237573nictating
nidating1039783ni_dating
notating92513343not_ating
nutating92411953nut_ating
obturating1346573obturating
outdating11810863outdating
outeating10814493outeating
outrating10916403outrating
pirating11314513pi_rating
pitting103618873pit__ting
rotating92614553rot_ating
saluting9310553salu_ting
sanitating1149653sanit_ating
sating74735453s___ating
scouting112612753scou_ting
seating84130683s__eating
sedating103014113s_edating
sensating1039253sensating
seriating10916403seriating
serrating10513213serrating
setting83621393set__ting
shitting123212663shit__ting
shouting122711793shou_ting
shunting123610433s_hunting
shuting113212053s_hu_ting
shutting12309693s_hutting
sibilating1346973sibilating
sifting113014593si__fting
sighting133110863si_ghting
signaling1136563signaling
signeting1136223signeting
silting83320483si__lting
sinuation9310413sinuation
sinuations1039413sinuations
siruping1136503siru_ping
siting74126623si___ting
sittings9339733sit__tings
situate7410783situat__e
situated938033situat_ed
situates8310373situat_es
situational1144583situational
skating123613853s__kating
slating83724653s__lating
slitting93012583slit__ting
smutting11278063s_mutting
snouting92511923snou_ting
solating9315593s_olating
solvating1336443solvating
spitting113012323spit__ting
spouting113511953spou_ting
spurting113111633s_purting
squaring18158633s_quaring
squatting1934513s_quatting
staging93818373s_t_aging
staking123919803s_t_aking
staling83925423s_t_aling
staning83922243s_t_aning
staring84527053s_t_aring
starting93116173s_tarting
statin63921473s_t_atin_
statins73719773s_t_atins
staving113915703s_t_aving
staying114017323s_t_aying
steading103613593s_teading
stealing93416603s_tealing
steaming114013213s_teaming
stetting93410713s_tetting
stilting93312403s_tilting
stimulating1445683stimulating
stinting93415743s_tinting
stipulating1445163stipulating
stotting92811163s_totting
strafing122111193s_trafing
strawing122411623s_trawing
straying122912693s_traying
striating10914193striating
strunting1037873strunting
strutting1037003strutting
stubbing13237453s_tubbing
studding1136703s_tudding
studying1335553s_tudying
stuffing15247843s_tuffing
stumming13347673s_tumming
stumping13289083s_tumping
stunning9298463s_tunning
sublating12310983sublating
suiting83419003s__uiting
sulfating1338063sulfating
summating1437943summating
suturing9310373sutu_ring
sweating123213023s_weating
tauting83316383__tauting
titivating1445323titivating
triturating1245433triturating
tufting11289873__tufting
tutting83515913__tutting
valuating1338653valuating
vibrating1537483vibrating
victualing1643403victualing
violating1337443violating
witting113417063wit__ting

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 Limit1486411597.48619855.9
3Display Results1591590.0632523.8
 (SQL Overall)1786911597.95522462.7
 
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.