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

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

56 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
rabbonis124501(None) 
rabboni1144801rabboni_
rabbinic1443122rabbinic
rabbinism1543372rabbinism
rabbins112811342rabbin_s
rabbis102613162rabb__is
ribbons1136252ribbon_s
abbots1039283_abbo_ts
abiosis939373_abiosis
adonis7314063_a_donis
ambones11312683_ambones
baboonish1653193baboonish
baboons113211083baboon_s
carbonic1439993carbonic
carbons115418943carbon_s
gabions102410053gabion_s
gaboons10289903gaboon_s
gibbons1234983gibbon_s
hambones1539673hambones
jawbones20134853jawbones
rabbets11279423rabb_ets
rabbi93113183rabb__i_
rabbies113416053rabb_ies
rabbin103112303rabb__in
rabbinisms1643163rabbinisms
rabbit102914563rabb__it
rabbits11299863rabb_its
rabblers123810853rabblers
rabbles113517973rabb_les
rabbling13239333rabbling
racons84319343ra_con_s
racoons93912433racoon_s
radionics1244393radionics
radons74118533ra_don_s
ramonas9311093ra_monas
ramsons939563ramson_s
ranis55235833ra___nis
rasboras1045893rasboras
rations74123433ration_s
ratoons73815473ratoon_s
rattons73815323ratton_s
raviolis1146103raviolis
rawboned14114253rawboned
rayons94113343ra_yon_s
redbones1137593redbones
ribbands1344563ribbands
ribbings13275923ribbings
ribbon1036533ribbon__
ribboned1343973ribboned
ribbonfish205973ribbonfish
ribboning1443513ribboning
ribbony1443543ribbon_y
robbins112811063robbin_s
rubbings13306333rubbings
sawbones13126643sawbones
tabbis102910863tabb__is

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.420425454.8
2DLD Change Limit146162567.76618820.8
3Display Results56560.0331697.0
 (SQL Overall)178691568.21921741.2
 
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.