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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
biased9401222(None) 
based85331581b_ased
biases84618431biases
biassed10418701biassed
abased96514992abased
baaed85218162b_aaed
baases85218012baases
bailed94726652bailed
baited95319242baited
baked126130772b_aked
baled85436442b_aled
baned85436352b_aned
bared85144482b_ared
base64847022b_ase_
baser74828922b_aser
bases75644352b_ases
bashed126225702b_ashed
basked135218602b_asked
basted95227232b_asted
bated85935532b_ated
bayed115423022b_ayed
beaded104922422beaded
beaked135919492beaked
beamed115720732beamed
beaned95621472beaned
bias64738152bias__
biasedly1443952biasedly
biasses94911652biasses
bibbed104712342bibbed
bided95424962bi_ded
biffed15449882biffed
biked125320032bi_ked
bilged105513182bilged
bilked134012942bilked
billed94224902billed
bilsted1038032bilsted
binged105920822binged
binned94414542binned
biped104718832bi_ped
birded104414302birded
birled94416992birled
birred94713202birred
birse74517402birse_
birses84717732birses
bise66437092bi_se_
bises75435622bi_ses
bitted94418482bitted
bladed104717762bladed
blamed116017952blamed
blared95018242blared
blase75524232blase_
blasted104213472blasted
blawed124713892blawed
blazed184314712blazed
blissed10388372blissed
boasted104113742boasted
boated94221972boated
bossed94816532bossed
boused95322882boused
bowsed125715972bowsed
braced115420602braced
braised104014802braised
braked135318692braked
brassed103612372brassed
braved124817442braved
brayed124615782brayed
brazed184717082brazed
bused85624492b_used
bussed94717052bussed
cased86032412_cased
ceased94920782ceased
chased125019292chased
dialed84716452dialed
dissed85220172dissed
eased65430402_eased
erased74816752erased
feased105718712feased
hissed104114452hissed
kissed114412852kissed
lased65132342_lased
leased74722882leased
liaised837112liaised
missed94423602missed
phased124011972phased
pissed94816932pissed
raised76120332raised
rased65033932_rased
rinsed75016352rinsed
teased74721152teased
unbiased1147142unbiased
vialed105112592vialed
visaed104110502visaed
vised95518762vi_sed
wised95123342wi_sed
wissed104114642wissed

Search took 3 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 Filter178691825510.1401276364.3
2DLD Change Limit82551952.70330540.5
3Display Results95950.0332878.8
 (SQL Overall)178691952.87662131.8
 
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.